Excel 2016 Tips and Tricks
Excel 2016
Lesson 2 – Working with Tables
Validating data using a list
NOTE The validation list can be stored in another sheet in the workbook, if desired. You could store all your validation lists in one sheet. To make it easy to use the validation lists, create a name for each list, such as RegionList , using the Name Box . In the Data Validation dialog box, you can then simply type =RegionList in the Source box to select the list. This also makes it easy to find and update a validation list if you need to add new entries. Use the Name Box to go to the list and insert cells within the list to contain the new entries. Any cells using RegionList for data validation will automatically recognize the new entries as valid entries.
P ROCEDURES
1. Select the column data for which you want to restrict data entry. 2. Select the Data tab. 3. Select the left-hand part of the Data Validation button
in
the Data Tools group.
OFFICEPRO, Inc.
Page 57
Made with FlippingBook flipbook maker