Excel: Overtime Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Error Message

An error message needs to be more than beeps and buzzers. Practical people want to know how to do the job right. Use the Error options to teach someone how to correct the mistake.

 

There are three alert styles : Stop, Warning and Information. For example, the Stop message has an annoying sound and too many buttons.

 

Try it: Edit the Validation Error

What is the difference between Retry and Cancel? Which choice deletes the wrong answer?

 

Data ->Data Tools-> Data Validation