How to create a drop down list with different options Excel 2010
1
0
73 Views
Published on 01/26/21 / In
How to
Steps to create a drop down list:
1. Select the cell or cells you want the drop down list to appear on
2. Go to the Data tab and select 'Data Validation'
3. Select 'list' for validation criteria
4. For the option source, select the range of options you have entered on your spreadsheet
5. Click ok and apply changes, you now have a drop down list
Show more
0 Comments
sort Sort By