• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Make Drop-Down Choice Buttons on an Excel Spreadsheet

How to Make Drop-Down Choice Buttons on an Excel Spreadsheet

By: R.L. Cultrona
  • Share
  • Share on Facebook

Microsoft Excel is a spreadsheet program that is part of the Microsoft Office Suite of office productivity programs. While this program is primarily used for data analysis, it is also good for building lists of information for later use. When building a list, oftentimes there will be a field in each entry which will always be one of several finite options. If this is the case, Excel has a function that allows you to input the options once and then place those options into a pull-down menu.

Young businesswoman eating lunch at desk
credit: Siri Stafford/Digital Vision/Getty Images

Step

Open Excel. Click on the Windows icon at the top of the the window and scroll down to "Open." Click on the command and browse through the folders on your computer to find your list. Click on it once to select it and click on "Open."

Step

Click on a blank sheet in the workbook (use the tabs on the bottom to select a blank sheet). Type the entries you would like to see in your drop-down list in a column with no spaces in between the entries.

Video of the Day

Step

Highlight the list so it is all selected. Click in the name box (this is a text box next to the function bar) and give your list a name (for example, you can name it which column you will be using the list in).

Step

Go back to your list and click in the first cell you want the drop-down list to occur. Click on the "Data" menu at the top of the screen and click on "Validation." Click on the "Settings" tab when the "Validation" window opens.

Step

Click on "List" in the "Allow" box. Type "=" and your list name in the "Source" box. Click on the box next to "In-Cell drop down." Click on the "Ignore Blank" box if the cell can be left blank. Once it is complete, click "OK."

Step

Right-click the cell you have just created the list and click on "Copy." Highlight the entire column, right-click, and click "Paste" to make every cell in that column into that drop-down list.

Show Comments

Related Articles

How to Insert a Cell Drop-Down Box in Microsoft Excel

How to Insert a Cell Drop-Down Box in Microsoft Excel

Around The Home
Productivity
By: Greg Lindberg
How to Delineate Commas in Excel

How to Delineate Commas in Excel

Around The Home
Productivity
By: Jason Artman
How to Create a Drop-Down List in an Excel Cell

How to Create a Drop-Down List in an Excel Cell

Around The Home
Productivity
By: Aaron Parson
How to Make a Drop Down List With Colors in Microsoft Excel 2003

How to Make a Drop Down List With Colors in Microsoft Excel 2003

Around The Home
Productivity
By: Anne Hirsh
How to Convert an R List Element to a Vector

How to Convert an R List Element to a Vector

Around The Home
Productivity
By: Damon Verial
How to Use Excel for a Questionnaire

How to Use Excel for a Questionnaire

Around The Home
Productivity
By: Darrin Koltow
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.