Data Validation in Excel - A Guide

How to use Data Validation in Excel - this allows you to control what a user can enter into a cell and helps you keep your data clean and free from errors.
Forms Course: www.teachexcel.com/premium-co...
5 Data Validation Tricks: • 5 Data Validation Tric...
Excel File: www.teachexcel.com/excel-tuto...
Excel Forum: www.teachexcel.com/talk/micro...
This tutorial serves as an introduction to data validation in Excel.
It shows you many data validation techniques, including:
- how to apply data validation
- how to make drop-down lists in Excel
- how to create custom input messages
- how to create cusotm error messages
- how to highlight errors for a user to clearly see
- how to make custom data validation and custom conditional formatting rules for Excel
This tutorial also combines custom conditional formatting with data validation in order to make a more useful input for for users.
I hope you enjoy this tutorial!
TeachExcel.com
#excel #tutorial #howto

[@PatsyColetta]

There's lots of outdated posts online and I was frustrated because I have a newer version where the Data Validation isn't where they say it should be.Less than 2 minutes into this video I got my answer. Woo hoo thanks!

[@toxiqrox]

I really like Data Validation, I use it at work mainly for lists. Thank you once again for an excellent tutorial.

[@TeachExcel]

I'm really glad you like it! This weeks tutorial provides more info on the lists part of things)

[@darrylmorgan]

Validation Lists Are A Godsend..Great Stuff Thank You Sir :)

[@TeachExcel]

You're very welcome)

[@wayneedmondson1065]

Hi.. some nice data validation tips and tricks there.. thanks for sharing them :)) Thumbs up for another excellent video!!

[@EricaDyson]

Very useful. Thanks. Was doing something like the other day but I didn't use all the features you've showed. I will in future!

[@TeachExcel]

I'm very glad I can give you some more tools for your Excel toolbox :)

[@usemybox]

Validation lists are very useful, especially when there is complex data to view. Good video

[@TeachExcel]

Totally agree! And thank you)

[@slasankautube]

I have learned lot of things in this tutorial , thank you

[@TeachExcel]

I am very glad to hear this :) You are very welcome!

[@lindsayrose1615]

Hi! I am currently following your video for Data Validation. I am making a drop down list. When I go to put my information into the source section it will not let me input all of my characters? Any tips on why this might be or how to fix this? Thanks!

[@venkatvilla5221]

They used Data Validation in Data Validation window. Haha lol 4:35