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

Written by greg lindberg
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Insert a Cell Drop-Down Box in Microsoft Excel
(Jupiterimages/Pixland/Getty Images)

The Microsoft Office Excel spreadsheet application includes a drop-down list feature that can be used to create different types of forms or make it simpler to limit entries specific to items you create in your spreadsheet. Before you utilise the drop-down feature you must create a list of options in a column. Once the drop-down list is created in a single cell box, users can then click on the arrow next to the cell to make the list you created appear. An item can then be select to fill the main cell.

Skill level:
Easy

Other People Are Reading

Things you need

  • Microsoft Excel

Show MoreHide

Instructions

  1. 1

    Open the Microsoft Excel 2003 application on your computer. Enter the data you want for your drop-down box into a single column of your spreadsheet.

  2. 2

    Click on the cell where you want the drop-down list to begin so that it’s selected. Click on the “Data” option from the top toolbar menu.

  3. 3

    Click on the “Validation” option and then click on the “Settings” tab. Click on the “List” option from the “Allow” box.

  4. 4

    Enter the reference for all of the cells to be used in the drop-down list into the “Source” box. Click on the box next to the “In-cell drop-down” field so that it’s selected.

  5. 5

    Change any other drop-down settings to meet your preferences and then click on the “OK” button. Your drop-down cell box will then be created.

  1. 1

    Open the Microsoft Excel 2007 application on your computer. Enter a list of data that you want for your drop-down list into a single column of your spreadsheet.

  2. 2

    Click on the cell where you want your drop-down list to begin so that it’s selected. Click on the “Data” tab and then click on the “Data Validation” option from the “Data Tools” group.

  3. 3

    Click on the “List” option from the “Allow” box. Click on the “Source” box and then select the column of cells you want for your drop-down list.

  4. 4

    Click on the box next to the “In-cell drop-down” field so that it’s selected. Make any other changes to the drop-down list settings and your drop-down box will be created in your spreadsheet.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.