Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

Data Validation

Unique Data Validation Drop-Down From Duplicate Table Data

By Jeff Lenning | September 10, 2014 |

In this post, we’ll explore a method for generating a drop-down that contains a unique list of choices derived from a table column with duplicate values. Objective Before we get started on the mechanics, let’s take a look at what we are trying to achieve. We have a data table that is exported from our…

Read More

Create Dependent Drop-down Lists with Conditional Data Validation

By Jeff Lenning | February 7, 2014 |

This post explores macro-free methods for using Excel’s data validation feature to create an in-cell drop-down that displays choices depending on the value selected in a previous in-cell drop-down. Overview As with just about anything in Excel, there are several ways to achieve the goal. This post explores three such solutions, and if you have a…

Read More

Custom Conditional Formatting Rules

By Jeff Lenning | July 11, 2013 |

Today, we will look at using conditional formatting with formulas, data validation, and comparison formulas.  Think you are up for it?  Let’s do this thing. Let’s say we have a worksheet that computes the payment of a loan.  We can use the PMT function to easily accomplish this task.  The PMT function requires three arguments…

Read More

Go To Special Places in Excel

By Jeff Lenning | April 25, 2013 |

Have you ever called up the Go To dialog in Excel? There is a little button in it that enables you to go to special places in Excel. This post explores some of these special destinations. For starters, let’s call up the Go To dialog within an empty workbook. There are a few different ways…

Read More

Data Validation Alert Styles

By Jeff Lenning | April 18, 2013 |

The Data Validation feature allows you to control what a user can type into a cell. This post digs into the details of the data validation alert style options. Data Validation Primer First, a quick overview of the Data Validation feature. Data Validation has been in Excel for a long time, and it is one of…

Read More