How to create Combo Box in Excel

When you edit or document in Excel and need to create a selection list, Combo Box will be a solution for you now. Let's find out how to create combo box for your Excel cell with TipsMake.com.

How to create Combo Box in Excel Picture 1

Combo Box in Excel is a function located in Excel's Developer ribbon, but this ribbon in Excel's default settings will not be visible to the user. So you need to display the Developer ribbon first.

First, open the File ribbon on the toolbar.

How to create Combo Box in Excel Picture 2

In the File list that appears, select Options in the list of options.

How to create Combo Box in Excel Picture 3

You will immediately see the Excel Options function window .

You switch to the Customize Ribbon tab in this window.

Next, you look to the Customize the Ribbon column and find the words Developer , tick the v before that line.

When you're done, click OK to confirm the Developer ribbon display setting .

How to create Combo Box in Excel Picture 4

Now you exit the main screen will see the Developer ribbon located next to the View ribbon on the toolbar.

How to create Combo Box in Excel Picture 5

Now, to insert the combo box into your worksheet, open the Developer ribbon , then click the Insert icon in the Controls group and select the Combo Box icon in the Form Controls list .

How to create Combo Box in Excel Picture 6

Use your mouse to drag out a suitable box size at the position you want.

How to create Combo Box in Excel Picture 7

After the Combo Box has been created, right click on it and select Format Control in the list displayed.

How to create Combo Box in Excel Picture 8

The Format Control window's window is turned on, open the Control tab, and then click the arrow icon of the Input range up arrow .

How to create Combo Box in Excel Picture 9

This way you can choose the list you want to display in Combo Box. This list must be available in your Excel data sheet. You highlight that array and press Enter .

How to create Combo Box in Excel Picture 10

After choosing the combo box list, you continue to choose the number of lines that will be dropped when using the Combo Box.

You can put traces in front of 3-D shading so that your Combo Box looks more like it sinks to the page.

How to create Combo Box in Excel Picture 11

You switch to the Properties tab to make some more settings related to Object positioning .

When you select Move but don't size with cells , you can move your Combo Box but cannot change the width and height of the box.

Don't move or size with cells , you can't change the size or move the box.

Finally click OK to confirm the installation.

How to create Combo Box in Excel Picture 12

Now you have a Combo Box to choose the list at your chosen location.

How to create Combo Box in Excel Picture 13

To save time for recreating the same Combo Box, you can choose how to copy and paste it into the remaining lines.

Right-click on the Combo Box and select Copy from the list.

How to create Combo Box in Excel Picture 14

Right-click the cell you want to insert and select Paste, or click the cell you want to insert and press Ctrl V.

How to create Combo Box in Excel Picture 15

Thank you for reading and following our article TipsMake.com on how to create combo box in Excel. Wish you can successfully implement this trick.