Learn Excel Now

Conquer the Fear of Excel

Keep up to date on all the newest live trainings, events, and tutorials.

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Excel Data Validation: An Introduction

December 7, 2016 by Tyrone Pernsley

Excel data validation allows you to set specific criteria for the type of data that can be entered into a cell or group of cells. In addition to creating that criteria, you can write a brief message on what can be entered into the cell and error message when the wrong information is entered.

In today’s example, we will use the following customer survey as our example:

data-validation-image-1

Here, we need to set data validation so only whole numbers between 1 and 10 can be entered. To do this, we will:

  • Go to the Data tab
  • Go to Data Validation
  • Open the Data Validation Dialogue box
  • On the Settings tab, set the range (whole numbers between 1 and 10)
  • On the Input message, enter our unique message
  • On the Error Alert tab, enter your custom error message

Once you hit okay, the rules will apply. Here is a demonstration in Excel:

data-validation

As you can see, the only numbers that can be entered are whole numbers between 1 and 10. There are a variety of reasons to use Excel data validation and it depends on the situation and problem you’re trying to solve.

We here at Learn Excel Now hope you found today’s lesson on Excel data validation useful.

Like Learn Excel Now? Follow us on social media and share our content with your networks! And don’t forget to sign up for the Newsletter

Kevin – Learn Excel Now

Filed Under: Excel Tools Tagged With: data validation, Excel 2013, excel data validation, excel tools

Keep up to date on all the newest live trainings, events, and tutorials.

Excel Power Tips: Shortcuts that Save Time & Eliminate Frustration
Simplify your life with essential Excel tips & shortcuts that will save you time and impress your colleagues.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Most Popular On-Demand Webinars

  • Excel Essentials: Most Needed Skills in Today's Workplace
  • Excel Power Tips: Incredible Shortcuts that Save Time & Reduce Frustration
  • Excel Formulas & Functions Bootcamp
  • Excel Dashboards for Beginners: Present Your Data Like a Pro
  • Advanced Formulas & Functions in Excel: Solve Your Data Challenges

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

Sitemap

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
384 Technology Drive
Malvern, PA 19355

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2020 ­ Learn Excel Now

Copyright © 2021 · News Pro Theme on Genesis Framework · WordPress · Log in