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.
Custom Error Message
Let’s take that same example and when the user enters an incorrect date, they will receive a specialized message.
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.
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