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:

Other People Are Reading


  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

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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