How To Make Drop Down List In Excel
How To Make Drop Down List In Excel. Then click the “data” sheet and select all the employees. Data validation dialogue box appears as follows.
If you don't want users to access the items on sheet2, you can hide sheet2. Within the data tools command group, select the data validation icon. On the settings tab, in the allow box, click list.
Go To The Data Tab.
For example, if you have new york, boston, and los angeles in cells, a1, a2,. Go to the data tab on the ribbon, then click data validation. Select a cell or range of cells where you want to create the drop down list.
Within The Data Tools Command Group, Select The Data Validation Icon.
On the settings tab, in the allow box, click list. Form validation criteria choose the list option. Data validation dialogue box appears as follows.
Click On The Data Tab.
To test the data validation, try entering both valid and invalid data into the cells. If you don't want users to access the items on sheet2, you can hide sheet2. Then click the “data” sheet and select all the employees.
To Create Drop Down List In Excel, Follow The Below Steps As Shown Below:
Once you're finished, click ok. In the data validation dialog box, within the settings tab, select list as the validation criteria. Click once in the “source:” field.
However, Do Not Include The Header Cell.
When you’re done click “ok”.
