Pinterest Pixel

Drop Down List with Data Validation

John Michaloudis
Drop Down List with Data Validation.
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.
Drop Down List with Data Validation | MyExcelOnline Drop Down List with Data Validation | MyExcelOnline

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.

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

Drop Down List with Data Validation

 

 

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  How to Change Row Color in Excel for Clearer Data

Steps To Follow

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!

Share to...