Drop Down List

Question

I would like to create a simple drop down list with a way to select the item. Anyone could help would be appreciated&nbsp;

amit_bhola · Answer

Katielac&nbsp;, it is explained here at this link&nbsp;https://support.office.com/en-us/article/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b

mtarler · Answer

Katielac&nbsp; this can be achieved using the 'Data Validation' option.&nbsp; Click on the 'Data' tab and in the 'Data Validation' group is 'Data Validation' (you may see an icon with the green check mark and red circle with a line through it)Select the cell(s) that you want the drop down and select Data Validation.&nbsp; Then select 'List' and make sure "In-cell dropdown" option is selected.&nbsp; Then in the Source either select a range of cells where the drop down options are located or you can add your own list: option a, option b, …&nbsp;

Forum Discussion

Drop Down List

2 Replies

Resources