• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Drop-down List in Excel

April 21, 2021 by Andrew Childress
Dropdown list Excel

A drop-down list allows you to select from a list of options rather than typing in the data. Here's how to create a drop-down list in Excel.

A drop-down list helps you control inputs into a cell. You can allow users to select from a list of options, rather than typing in their own data. These are easy to build with spreadsheets. Let’s learn how to create a drop-down list in Microsoft Excel.

How to Create a Drop-down List in Excel

Drop-down lists let you guide users through inputs. They’re useful in cases where you want to ensure those inputs match the style and formatting that you’ve chosen for the entire workbook.

Let’s plan to place a drop-down list in cell C1 of a worksheet. The inputs will be five weekday options. It’s easiest to place the actual data on a separate worksheet, so open up Sheet2 by clicking at the bottom of your file.

Then, type the list in a column: Monday, Tuesday, Wednesday, Thursday, and Friday. Now, it’s time to create the actual drop-down list.

Drop down Excel

Return to Sheet1, and open the Data tab on the ribbon. On the right side, you’ll see the Data Validation drop-down arrow. Click here.

Drop down list Excel

You’ll see three options, and the one you want is Data Validation at the top. Click it, and now Excel will ask for criteria on the popup menu. This is where you tell Excel how to format your data, and where to find it within the workbook.

From the Allow drop-down, choose List. Then, with the Source field selected, go back to Sheet2 and highlight your data. The input should be:

=Sheet2!$A$1:$A$5

Dropdown list Excel

Finally, press OK. You’ll see cell C1 now contains a drop-down arrow. Click on it, and you’ll see the drop-down list you created.

Create a dropdown list in Excel

As you can see, it’s easy to make a drop-down list in Microsoft Excel. You can quickly choose custom fields and place them inside any cell that you choose. This is a great way to keep control over your workbook.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Merge Cells in ExcelMerge and Center in Excel
Next Post:Dollar Sign in ExcelDollar sign in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top