EXCEL 2022: The All In One Step-by-Step Guide From Beginner To Expert. Discover Easy Excel Tips & Tricks to Master the Essential Functions, Formulas & Shortcuts to Save Time & Simplify Your Job by Wang Mike

Author:Wang, Mike [Wang, Mike]
Language: eng
Format: epub
Published: 2021-12-30T16:00:00+00:00

How to Insert Data Validation

To add data validation, follow the procedures below:

Select the cell you wish to validate.

From the Data tab , go to the Data Validation button and click on it.

On the Settings tab , modify the validation criteria according to what you have in mind, and then click on Ok.

You can add an input message by clicking on the Input Message box to enter the title and text of your message relating to the field and click on Ok.

You can display an error alert by clicking on Error Alert and moving to the Style box to select the alert type. Then enter the title and text of the error message and then click on Ok .

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.