watermark logo

Up next

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

33 Views· 26 Jan 2021
DIGI SAKSHAM
DIGI SAKSHAM
3 Subscribers
3
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


Up next