Excel 2016 Tips and Tricks

Excel 2016

Lesson – 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