Pinterest Pixel

Drop Down List with Data Validation

One of the coolest features of Excel is to create a drop down list with your data. ... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

One of the coolest features of Excel is to create a drop down list with your data.  It is one of the first things that I learned and use on a daily basis.

You can create a drop down list to eliminate manual entry and re-entry of data, as well as reduce data entry mistakes if you rely on other users entering data.

Data Validation lists can also be used on a form or a template where external users can choose from the drop down list to enter their choices.

Want to know how to use the Excel Data Validation?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch it on YouTube and give it a thumbs-up!

Download the YouTube Excel practice file

 

STEP 1: Click on the cell that you want to enter your list in

Drop Down List with Data Validation

STEP 2: Go to the ribbon and choose Data > Data Validation > List

Drop Down List with Data Validation

STEP 3: Click in the Source box and select the range that includes your list of text/values and press OK

See also  Text to Columns - Emails

Drop Down List with Data Validation

Drop Down List with Data Validation | MyExcelOnline
DOWNLOAD WORKBOOK

WATCH ON YOUTUBE

 

Helpful Resource:

Connect Slicers to Multiple Excel Pivot Tables

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!