Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016

NOTE You can enable the Apply these changes to all other cells with the same settings option on the Settings page in the Data Validation dialog box. This option applies any changes you have made to all cells that contain the same data validation as the changed cells. You can use the Input Message page in the Data Validation dialog box to create a message that appears in a ScreenTip when the user selects a cell. This message can provide information for the user about the type of data to be entered.



P ROCEDURES

1. Select the column data for which you want to customize the error message. 2. Select the Data tab. 3. Select the left-hand part of the Data Validation button in the Data Tools group. 4. Select the Error Alert tab. 5. Select the Style list. 6. Select the desired style.

7. Select the Title box. 8. Type the desired title.

9. Select the Error message box. 10. Type the desired error message. 11. Select



S TEP - BY -S TEP Create a custom error message.

Steps

Practice Data

1. Select the column data for which you want to customize the error message. The column data is selected.

Click above Year

2. Select the Data tab.

Click Data

The Data tab is displayed.

Page 60

OFFICEPRO, Inc.