Excel Create dropdown list on Mac Creating a dropdown list in Excel on a Mac works in a very similar way That is how it goes Open a new Excel table and enter the names of the participants in column A of the document, for example On the worksheet, select the cells where you want the dropdown list to appearNow you need to tell Excel where to find the data for the dropdown list Click on the icon on the right of the 'Source' box Here we'll click through to the spreadsheet 'Months' and select all months we want to include in the list Press 'Enter' – and you've defined the contents of your dropdown list! The easiest way is to use the INDIRECT function to create a reference to an Excel Table column References pointing to an Excel Table are called " structured references ", they are different from regular cell references Cell B15 contains a dropdown list with this formula =INDIRECT ("Table1 First Name")
How To Create Drop Down List With Data Validation In Excel