Excel 2016 Tips and Tricks

Excel 2016

Lesson – Working with Tables

Steps

Practice Data

4. Select Clear All .

Click

The restrictions are cleared on all pages in the Data Validation dialog box.

5. Select OK .

Click

The Data Validation dialog box closes and data validation is removed from the selected cells.

Click in any cell to deselect the range. Close TABLE2.XLSX.

OFFICEPRO, Inc.

Page 63