How to Use Data Validation in Excel [Quick Excel Tutorial] #exceltutorial #datavalidation

Do you like our content? Buy us a cup of coffee! ☕
ko-fi.com/burntolearn

Let’s ensure the quality of your data by applying data validation in just a few simple steps:
Select the cell or range of cells where you want to apply the data validation.

Now go to the Data tab and click on the Data Validation button.

A new window is opened with several options. In the settings tab you can set a range of acceptable values, restrict input to a specific data type or create custom formulas to validate the data.

In the input message tab you can customize the message you want displayed when the criteria you set up is triggered. And in the error alert tab you can set the error alert that will appear when invalid data is entered. To conclude the process just click on the ok button and that’s it!

Data validation in Excel allows you to set rules and restrictions for data entry, preventing errors and ensure the quality of your data.

🔔 Subscribe to our YouTube channel
youtube.com/c/BurntoLearn

Burn To Learn - T-Shirts 👕
burntolearn.threadless.com/designs

Visit our website www.burntolearn.com/ to see all our tutorials.
Facebook: www.facebook.com/burtolearn/
Twitter: twitter.com/btltutorials
Instagram - www.instagram.com/btltutorials/
LinkedIn - www.linkedin.com/company/burntolearn.com/
Reddit - www.reddit.com/user/burn-to-learn/

------------------------ --------------------------- ------------------------------

#microsoft #excel #exceltutorial #quicktutorial #datavalidation #exceltips