Excel 2016 Tips and Tricks

Excel 2016

Lesson – Working with Tables

Steps

Practice Data

8. Select the list range in the worksheet. A blinking marquee appears around the selected range and the address appears in the Data Validation dialog box. 9. Click the Expand Dialog button in the Data Validation dialog box. The Data Validation dialog box expands. 10. Select or deselect the Ignore Blank option, as desired. The option is selected or deselected accordingly.

Select G1:G5, and release the mouse button

Click in the Data Validation dialog box

Ensure

Ignore Blank is

selected

11. Select or deselect the In-cell dropdown option, as desired.

Ensure In-cell dropdown is selected

The option is selected or deselected accordingly.

12. Select OK .

Click

The Data Validation dialog box closes and data validation is applied to the selected cells.

Select cell C10. Notice the drop-down arrow that appears to the right of the cell. Click the drop- down arrow and select Southeast from the list. Type West into cell C10 and press [Enter] . A Microsoft Office Excel message box opens, informing you that your entry is not valid. Select Cancel to close the message box. Click the drop-down arrow and select Northeast .

C REATING A C USTOM E RROR M ESSAGE  D ISCUSSION

When a user enters an invalid entry into a cell with restricted data entry, Excel opens a message box, informing the user that the entry is invalid. You can create a custom alert message that appears in the message box instead of the default message.

Excel includes three styles of alert message boxes: Stop , Warning , and Information . Each style provides different buttons in the message box and, more importantly, different restrictions. The default error alert style is Stop , which does not allow invalid data to be entered into cells. Both the Warning and Information styles allow invalid data to be entered.

OFFICEPRO, Inc.

Page 59