Excel 2016 Tips and Tricks

Lesson – Working with Tables

Excel 2016

Using data validation

NOTE You can copy the data validation from one cell to another using the Validation option in the Paste Special dialog box. Selecting Custom from the Allow list on the Settings page in the Data Validation dialog box allows you to enter or refer to cell containing a logic formula. The formula must calculate a true or false result, with true results being valid entries and false results being invalid entries. You can use the Data Validation feature for any cell data. Its use is not restricted to Table data.



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. 4. Select the Settings tab. 5. Select the Allow 6. Select the desired option.

list dropdown.

Page 54

OFFICEPRO, Inc.