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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

How To Create A Custom List In Excel  A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers.The main goal of a custom list is to remove repetitive work and manual errors i...
How to Calculate Percentage in Excel In calculating percentages in Excel, there are a lot of ways that you could do this:What is the percentage of a number? What is the percentage change of value i.e. The percentage increase or decrease What is the proportion against a total value?Let us go over ...
Convert Values to Dates Using Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column.One of the cool uses of Flash Fill is convert your values into Excel dates a...
Clear a #REF! Error in Excel When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error.This means that the formula refers to a cell that isn’t valid.To get rid of this error message we have to select the cell(s) with this error, ...