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 | MyExcelOnline

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

Drop Down List with Data Validation | MyExcelOnline

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

data validation list

Drop Down List with Data Validation | MyExcelOnline

DOWNLOAD WORKBOOK

WATCH ON YOUTUBE

 

Helpful Resource:

Drop Down List with Data Validation | MyExcelOnline

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn