Data Validation Archives • My Online Training Hub

April 20, 2020

Select Multiple Items from Drop Down (Data Validation) List

Data validation lists will only let you choose one item from the list. But what if we have a situation

April 9, 2020

Creating this searchable drop down list in Excel is so easy I’m wondering why I never thought of it before.

March 3, 2016

If you want to limit the choices available for the values that can be entered into a cell, you could

September 25, 2015

If you are using data validation (and you should) to help you with your data entry, then you might find

September 15, 2014

In this tutorial we're going to look at how Santa is using Excel Custom Data Validation to limit the number

June 5, 2013

Data Validation or Drop Down Lists are one of Excel’s greatest features, but I have one gripe with them, and

April 30, 2013

I’ve set up a table with some team names that I want to use in a Data Validation list. The

October 24, 2012

This Excel Factor tip was sent in by Marc Joannette of Montreal, Canada. Words by Mynda Treacy. Marc's job involves

October 17, 2012

This Excel Factor tip was sent in by Roberto Mensa of Italy. Words by Mynda Treacy. Data validation lists are

February 8, 2012

Using Data Validation to restrict what gets entered in a cell or range of cells is great for standardising your

November 21, 2010

Creating Excel drop down lists, or Data Validation Lists as they're formally known, enables you to control the value entered