How to Validate Data in Microsoft Excel

Barb was out at Eastern Health on Friday doing an Intermediate Excel course.  The attendees wanted to do some work on data validation and while the manual contained the basics of validation, they needed more.  So Barbie very graciously wrote this 9 page handout over the weekend, which I share with you all now. Data Validation in Excel

Ah, but what is data validation you ask? 

Well, Data Validation allows you to restrict the data entered into a range of cells in an Excel worksheet. For example, if you have created a worksheet that others use, you need to ensure that only data that matches your requirements is entered into those cells, perhaps a range of numbers (e.g. between 10 and 20), or only specific text (e.g., Mr., Mrs, or Miss).

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s