Image Image Image Image Image Image Image Image Image Image

In Tech We Love | October 24, 2017

Scroll to top

Top

No Comments

Top Mac Excel Tips - Creating a drop down list - In Tech We Love

intech

Creating a drop down list

Select the column or list of cells you want to use to populate your drop down list. This can be on the same sheet or a different to the one you want to display your drop down list on.

Go to Insert > Name > Define

Add the name you want to use to reference the list, for example mylist & press ‘Ok’

Go to the cell in which you want to display your drop down list.

Go to Data > Validation

In the allow drop down select ‘List’

In source type write = followed by the name you gave your list, for example =mylist

Press ‘Ok’, your drop down list should now appear when you click on the cell you added it to

 

 

 

Next Story

This is the most recent story.

Submit a Comment