Untitled Document

Advance Features in excel 2007

Add an error message to an Excel 2007

You can also restrict what goes in to a cell on your spreadsheet, and display an error message for your users. We'll do this with our Comments column. If users enter too much text, we'll let them know by displaying a suitable error box. Try the following:

.	Highlight the E column on your spreadsheet (the Comments column)
.	From the Data Tools panel,
 click Data Validation to bring up the dialogue box again
.	From the Allow list, select Text length:

When you select Text Length from the list, you'll see three new areas appear:

What we're trying to do is to restrict the amount of text a user can input into any one cell on the Comments column. We'll restrict the text to between 0 and 25 characters.

The first of the new areas (Data) is exactly what we want - Between. For the minimum textbox, just type a 0 (zero) in there. For the maximum box, type 25. Your dialogue box should then look like this:

To add an error message, click the Error Alert tab at the top of the Data Validation dialogue box:

Make sure there is a tick in the box for "Show error alert after invalid data is entered".

You have three different Styles to choose from for your error message. Click the drop down list to see them:

In the Title textbox, type some text for the title of your error message.

Now click inside the error message field and type some text for the main body of your error message. This will tell the user what he or she did wrong:

Click OK on the Data Validation dialogue box when you're done.

To test out your new error message, click inside any cell in your Comments Column. Type a message longer than 25 characters. Press the enter key on your keyboard and you should see your error message appear:

As you can see, the user is prompted to Retry or Cancel. But our title (Too many characters) is at the top, our Stop symbol is to the left, and our Error message is displaying nicely!

For Animated Presentaiton Click Here!