Forum Discussion
Katielac
May 21, 2020Copper Contributor
Drop Down List
I would like to create a simple drop down list with a way to select the item. Anyone could help would be appreciated
2 Replies
Sort By
- mtarlerSilver Contributor
Katielac this can be achieved using the 'Data Validation' option. 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. Then select 'List' and make sure "In-cell dropdown" option is selected. 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, …
- amit_bholaIron Contributor
Katielac , it is explained here at this link https://support.office.com/en-us/article/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b