Create a drop-down list by selecting a range of cells The most common way to create a drop-down list in Excel with multiple selections is by using a range, which relies on using data from other cells.

Click the Lists sheet tab or the tab that contains your list items. Select the list (A1:A4). Click OK, which will return you to the new sheet, where you’ll find a populated list in E4 (Figure A).

If you have a list of email addresses in an Excel spreadsheet, you can import this into a Mac Address Book by converting the Excel file into a text-based Comma Separated Value file.