Data validation


Excel » Features » Data validation »

Add new items to a drop down list automatically

A drop down list in excel prevents a user from entering an invalid value in a cell. Did you know that you […]

Quickly change chart data source

In excel it is not easy to change a chart´s data source without manually changing the data source in chart […]

Prevent duplicate records [Data Validation]

Debra Dalgleish demonstrated last week how to block duplicate entries in excel table. I made a comment and I thought I would share […]

Use drop down lists to compare data series in an excel chart

The two drop down lists below the chart let´s you compare two data series from separate tables. It is easier […]

Use a map in an Excel chart

This post describes how to add a map (background picture) to a chart. The following animated picture shows a scatter […]

Dynamic data labels in a chart

My fascination for charts and vba continues (see previous posts). This post demonstrates how to highlight a group of values […]

Run a Macro from a Drop Down list [VBA]

This article demonstrates how to execute a VBA macro using a drop down list. The drop down list contains multiple […]

Drop down list changes cell formatting

You can apply different conditional formatting formulas and formatting to a cell range, using a drop down list. Here is […]

Prevent users from entering overlapping date and time ranges

The picture below shows a table with data validation applied. If a user tries to enter an overlapping date range, […]

How to use a Table name in Data Validation Lists and Conditional Formatting formulas

David Hager gave this valuable comment about how to reference a table name in conditional formatting formulas: =INDIRECT("Table1[Start]") Watch this video to […]

Use filtered table values in a drop down list [VBA]

I read a very interesting blog post about Using Custom Functions in Dynamic Ranges Gabhan Berry creates a user defined […]

Use a drop down list to extract and concatenate unique distinct values

Question: Is there a way to have a unique list generated from a list? Meaning I have a sheet that […]

Use a drop down list to select company info in header (vba)

Aynsley Wall asks: I have a spreadsheet that I use for 3 different companies. What i would really like to […]

Apply data validation lists dynamically [VBA]

Table of Contents Applying Drop Down lists dynamically using an Excel Defined table Applying Drop Down lists dynamically (vba) Add […]

Dependent data validation lists in multiple rows

This post describes how to setup data validation lists in a column and dependent data validation lists in an adjacent […]

Basic invoice template

Rattan asks: In my workbook I have three worksheets; "Customer", "Vendor" and "Payment". In the Customer sheet I have a […]

Use a drop down list to search and return multiple values

Ainslie asks: I have multiple worksheets in an excel book. I have a drop down menu on the worksheet entitles […]

Change chart data range using a Drop Down List [VBA]

This blog post demonstrates how to quickly change chart data range. I have created a drop down list (form control) […]

Change pivot table data source using a drop down list

In this excel 2007 tutorial I am going to show you how to quickly change pivot table data source using […]

Use dynamic ranges to automatically add new values

This post demonstrates how to automatically add new values to a drop down list and a chart. This tutorial contains […]

Dependent drop down lists – Enable/Disable selection filter

Josh asks: I have this working right now with 6 drop downs/lists. I wanted to see if you possibly know […]

Create a drop down calendar

This drop down calendar uses a "calculation" sheet and a named range. You can copy drop down lists and paste […]

Invoice template with dependent drop down lists

Overview This post descibes how to use a basic invoice template I created. The invoice template let´s you use dropdown […]

Create dependent drop down lists containing unique distinct values in multiple rows

Sharmila asks: How can i use these list for multiple rows? I would like to use these lists for multiple […]

Apply dependent combo box selections to a filter

Josh asks: now if i only knew how to apply these dependent dropdown selections to a filter, i'd be set. […]

Create a drop down list containing alphabetically sorted values

Overview This article describes how to create a drop down list populated with sorted values from A to Z. The […]

Create dependent drop down lists containing unique distinct values

This article explains how to build dependent drop down lists. Here is a list of order numbers and products. We […]

Create a drop down list containing only unique distinct alphabetically sorted text values

Question: How do I create a drop-down list with unique distinct alphabetically sorted values? Table of contents Sort values using […]