Error Alert Tab

In this topic, we will look at the Error Alert Tab.


This will allow a message to appear when invalid data is entered.


  1. From the Data Tab, click the Data Validation drop down menu.

    Step 1
  2. Click  Data Validation

    Step 2
  3. Click the Error Alert tab.

    Step 3
  4. Select your Style:


    Click the Style: drop down menu.

    Step 4
  5. Stop - allows the user to select Retry or Cancel.

    Step 5
  6. Warning - allows the user to click Yes to accept the invalid entry; No to edit the invalid entry; or Cancel to remove the invalid entry.



    Step 6
  7. Information -  This is the most flexible alert.  This allows the user to click OK to accept the invalid value or Cancel to reject it. 

    Step 7
  8. In this example, we'll use Stop.


    Click the Stop list item.

    Step 8
  9. Click in the Title: field.

    Step 9
  10. Enter a title for your error message.  In this example, we'll enter Error.


    Step 10
  11. Click in the Error message: field.

    Step 11
  12. Type the error message you want to appear when invalid data is entered.  In this example, enter "The only allowable value is a two-character State abbreviation."

    Step 12
  13. Click the OK button.

    Step 13
  14. Enter the State.   In this example, enter California.


    Step 14
  15. Press [Enter].

    Step 15
  16. Note the Error Alert.



    Click the Retry button.

    Step 16
  17. Enter the abbreviation for California.   In this example, enter CA.

    Step 17
  18. Press [Enter].

    Step 18

After completing this topic, you are familiar with the Error Alert Tab.