Show Input and Error Messages with Excel Data Validation

preview_player
Показать описание
Visit this page to download the sample file.

With data validation, you can control what is entered in a cell, and prevent invalid data.

To help people enter the correct information, you can show an input message when the cell is selected. Give a brief description of what can be entered in the cell.

You can also create an error message, which appears if invalid data is entered. The error message can stop invalid data, or show a warning but allow the invalid data.

This video shows you how to set up the data validation to allow a whole number between 1 and 10. Then, add an input message and an error message.
Рекомендации по теме
Комментарии
Автор

I was having trouble with my E Class Record and thank God I found this video. This really helped me at 11:40PM. Thank you🙏🙏

bernie.fuentes
Автор

In the error message field do you happen to know if you can add a line break to it so as to split up the message so it's not all on one line?

dstdg