Data validation allows users to test the integrity of the contents of a cell based on validation rules. In this video, Jess Stratton shows you how to create validation rules based on the contents of cells, and even add drop-down lists to cells.
- [Instructor] You can make sure the integrity of your data…stays nice and clean by using cell validation.…You can validate every cell to make sure…the formatting fits certain criteria…such as data, text strings, or even restricting values…to a drop-down list of choices.…Google Sheets makes it incredibly easy to add validation.…Let's add some validation to this email column…to make sure a valid email address is entered.…I'll start by clicking the column header in D…to select the entire column.…From here, click Data,…and all the way on the bottom, click Validation.…
First, I need to check and make sure…the correct cell range is covered.…In this case, it's the entire column of D.…That's what I want.…The next step is to choose the criteria.…If I click the drop-down next to List from a range,…here's all of the validation I can do.…I'll go over range values and a list of items later,…but you can also validate based on number,…text, date, even a custom formula that you create.…I'm going to click Text for now.…Once I click Text, I get a further drop-down,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons