watermark logo

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

66 Views
DIGI SAKSHAM
3
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