Excel 2016 Tips and Tricks

Lesson – Working with Tables

Excel 2016

Select cell E12. Type 2005 and press [Enter] . Notice that the error message does not allow you to continue with an incorrect entry. Click the Cancel button to close the message. Type 2007 in cell E9. R EMOVING D ATA V ALIDATION  D ISCUSSION You can remove all the restrictions on data entry in a cell by clearing the data validation from the cell. Removing data validation allows any entry to be entered in a cell.

NOTE Selecting the Clear All button on any page in the Data Validation dialog box clears the restrictions on all the pages for the selected range.



P ROCEDURES

1. Select the cells with the data validation you want to remove. 2. Select the Data tab. 3. Select the left-hand part of the Data Validation button

in

the Data Tools group.

4. Select Clear All . 5. Select

.



S TEP - BY -S TEP

Remove data validation.

Steps

Practice Data

1. Select the cells with the data validation you want to remove. The cells are selected.

Click above Year

2. Select the Data tab.

Click Data

The Data tab is displayed.

3. Select the left-hand part of the Data Validation button in the Data Tools group. The Data Validation dialog box opens.

Click

Page 62

OFFICEPRO, Inc.