On the first sheet, select cell b1.

How to add drop down list in excel for mac. Set up your first drop down list. You can create your list on the same. Web whil e insert drop down list excel with windows may be simple, mac is on the same page in creating this list for quick and accurate data entry with the following.

It happens when you click a small drop down arrow in the cell and it shows you a list of. In the source box, either update. Alternatively, you can click file > options > customize ribbon.

1) create a spreadsheet and enter the items on your list into it. 2) select the cell into which you would want to place the drop. On the second sheet, create the following named ranges.

Select the data you want to use and type a name for it in the name. Select the second cell that.