Training Tip - Validate your data in Excel
7th August 2010
... Comments

Data Validation in Excel

You can set Excel up to allow you or someone else to enter data that meets criteria that you set.


For example, on an order form, the quantity to be ordered may be in a particular range. Say between 10 and 20 units. You can set this up so that if the person entering the data puts a number in that is below 10 or above 20 Excel will do any of several things:

  • Display an Error  Message and allow you to continue
  • Display an Error Message and stop you from entering invalid data
  • Display an Error Message for information only

Data Validation in Excel 2007 and Excel 2010


Data Validation in Excel 2008


For more handy tips for working with Microsoft Office on either the Windows or the Mac platforms sign up for our weekly newsletter at: click the Register Now button and you will receive a weekly email with that week's tip.


Drop me a line if you would like me to write a tip especially for you. Email with the subject line TIPS.


Remember, we can supply all of your IT Training needs - we run Training Surgeries, where your staff can get targeted one to one support or we can run full day training courses for your business or organisation.


Call 0800 088 7346 for more information.


Have a brilliant week.



follow me on twitter @shelleyfishel


About the Author

Shelley F

Member since: 6th January 2011

Shelley Fishel is the Founder and Managing Director of The Training Surgery, an IT training company that focuses on the needs of the clients. Training in your office, with your documents focussed on your...

Popular Categories