Using Data Validation in Excel

On occasion, you may find that you need your users to enter data in a spreadsheet in a specific format. There are a few ways to do this, but I find the “Data Validation” feature easy to use and quick to set up.

Let’s get right into a few examples.


Enter Only Dates in a Specified Range

You’ve got a spreadsheet that you want the users to only be able to enter dates in a specific range.

Data Validation Date


Custom Error Message

Let’s take that same example and when the user enters an incorrect date, they will receive a specialized message.

Data Validation Error


Create a Drop-Down List

This is a fun one! You can create a drop-down list based on an existing list! The list can be on a separate sheet, but for this example I’ve kept it in one place.

Data Validation List


What other ways can you think of using Data Validation? I’ve found it to eliminate a lot of errors and it’s easy to set up!



About Harbor Computer Services

Harbor Computer Services is an IT firm servicing Southeastern Michigan. We work exclusively under contract with our clients to provide technology direction and either become the IT department or provide assistance to the internal IT they already have. We have won many awards for our work over the years, including the worldwide Microsoft Partner of the Year in 2010. We’re the smallest firm to have ever won this most prestigious award. Most recently we were recognized as one of the top 20 visionaries in small business IT by ChannelPro Magazine (2015). And in 2016 as the top Michigan IT firm for Manufacturing. There are a few simple things that make Harbor Computer Services the best choice for your business. •We are Professionals •We are Responsible •We are Concerned About The Success of Your Business

Leave a comment

Your email address will not be published. Required fields are marked *