Data Validation Options

Published on: September 13, 2015

Welcome to the 15th Excel Tutorial where I show you a bit more on data validation. Last time, I covered how to validate using dropdown lists, but there are more options, more ways to customize your validation items to fully idiot-proof your spreadsheets.

If you know how to validate using one option, you will know how to validate using the others. I go over the various settings, input messages, and Error Alerts. You can customize these settings to your heart's desire.

I hope you enjoy this quick tutorial and if you have any questions, feel free to ask.

Remember to checkout the Resources section below for associated downloadable content, JSFiddle links, and other resources. Watch the video and follow along!


Download the associated Excel Spreadsheet here: Download