Excel 2016 Tips and Tricks

Excel 2016

Lesson – Working with Tables

7. Select the Data

list dropdown.

8. Select the desired option. 9. Enter the desired limits. 10. Select or deselect the Ignore Blank option, as desired. 11. Select OK .



S TEP - BY -S TEP From the Student Data directory, open TABLE2.XLSX . Use data validation to restrict data entry.

Steps

Practice Data

1. Select the column data for which you want to restrict data entry. The column data is 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

4. Select the Settings tab.

Click Settings , if necessary

The Settings page is displayed.

5. Select the Allow list.

Click Allow

A list of options is displayed.

6. Select the desired option.

Click Whole number

The desired option appears in the Allow box.

7. Select the Data list.

Click Data

A list of options is displayed.

8. Select the desired option.

Click between

The desired option appears in the Data box and one or more boxes (depending on the option selected) appear below the Data box for entering limit values.

OFFICEPRO, Inc.

Page 55