watermark logo

How to create a drop down list with different options Excel 2010

15 Views
DIGI SAKSHAM
2
Published on 26 Jan 2021 / 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