Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016

4. Select the Settings tab. 5. Select the Allow list. 6. Select List . 7. Click the Collapse Dialog button 8. Select the list range in the worksheet. 9. Click the Expand Dialog button

in the Source box.

in the Data Validation dialog box.

10. Select or deselect the Ignore Blank option, as desired. 11. Select or deselect the In-cell dropdown option, as desired. 12. Select



S TEP - BY -S TEP Validate table data using a list.

Steps

Practice Data

1. Select the column data for which you want to restrict data entry. The column data is selected.

Click above Region

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 List .

Click List

List appears in the Allow box and a Source box appears.

7. Click the Collapse Dialog button in the Source box. The Data Validation dialog box collapses.

Click

in the Source

box

Page 58

OFFICEPRO, Inc.