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.

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

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

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

data validation list

DOWNLOAD WORKBOOK

WATCH ON YOUTUBE

Data Validation List

Helpful Resource:

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