How to Make a Combo Box in Excel 2003

Written by lara webster
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Combo Box in Excel 2003
(Erik Snyder/Lifesize/Getty Images)

Microsoft Excel provides many ways to organise and display data, one of which is the combo box. Combo boxes provide a drop-down menu, which affords users the ability to select which data they want to view. Making a combo box can save space in a spreadsheet and make finding specific data much simpler.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Open Excel on your computer, and open a new spreadsheet. Somewhere in the spreadsheet, enter the data that will appear in the combo box. For example, you might enter data between cells C4 to C10.

  2. 2

    Go to the "Forms" toolbar, and select "Combo Box."

  3. 3

    Drag your mouse over the cells that you want the combo box to encompass. Once you release your mouse click, the combo box will appear.

  4. 4

    Right-click on the new combo box,, and choose "Format Control" from the menu. Specify the cell range of your data in the "Input Range" field; in the above example, you would enter C4:C10, because those are the cells that hold your data.

  5. 5

    Go to the "Cell Link Box," and enter the number of the cell where you want the index value of items selected in the combo box to appear. Click "OK."

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.