Using the Data Validation feature in Excel you are able to restrict entry to a predefined list of values.
In many cases spreadsheets
are completed by more than one user which often results in different styles of
inputting data. By having a drop down
list to select from ensures consistency which not only makes for a neater
appearance, but also significantly improves the ease of use of tools such as
Pivot Tables and Filters.
- Somewhere in your spreadsheet, type out the list of values that you would like to use as the source for your drop down list
- Select the cells to which you would like to add Data Validation drop down list
- On the Data tab, select Data Validation. (A drop-down menu will appear.)
- Select Data Validation.
- Select List from the Allow drop down.
- In the Source field, select the range of cells that will act as the source data for the drop down list
- Click OK and begin using the drop down list to aid data entry
Happy spread-sheeting! Please share if you found this useful.
No comments:
Post a Comment