Excel 2016 Tips and Tricks

Excel 2016

Lesson – Working with Tables

Steps

Practice Data

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 Error Alert tab.

Click Error Alert

The Error Alert page is displayed.

5. Select the Style list.

Click Style

A list of styles is displayed.

6. Select the desired style.

Click Warning

The desired style appears in the Style box.

7. Select the Title box.

Click in the Title box

The insertion point appears in the Title box.

8. Type the desired title.

Type Year Error

The text appears in the Title box.

9. Select the Error message box.

Click in the Error message box

The insertion point appears in the Error message box.

10. Type the desired error message. The text appears in the Error message box.

Type Year should be between 2006 and 2010!

11. Select OK .

Click

The Data Validation dialog box closes and the error message is saved.

Type 2005 in cell E9 and press [Enter] . A warning box opens with your custom title and message. Select Yes to enter your text despite the warning. Notice the green triangle in the top-left corner of cell E9. Select cell E9. Notice the Error button that appears beside the cell. Although Excel allowed the entry, it still warns that the entry violates data validation rules.

With cell E9 selected, click the left-hand part of the Data Validation button in the Data Tools group. On the Error Alert page, change the Style to Stop . Change the word should in the Error message box to must . Click the Settings tab and select the Apply these changes to all other cells with the same settings option. Click OK .

OFFICEPRO, Inc.

Page 61