Tuesday, June 11, 2013

How to Put a Combo Box in an XLS Cell


1. Open the Excel document to which you want to add a combo box.
2. Click on 'File' in the top-left corner of the Excel window. Choose 'Options' from the list that appears.
3. Select 'Customize Ribbon' on the left side of the new window. Place a check mark next to 'Developer' on the list located to the far right side of the window. Click 'OK.'
4. Click the 'Developer' tab at the top of the screen. Select 'Insert' and choose 'Combo Box (Form Control),' which will be the second option from the left in the top row. Select a cell where you want to enter the combo box.
5. Right-click the combo box and choose 'Format Control' from the drop-down menu. Click the 'Control' tab at the top of the new window. Type in a range of cells into the 'Input Range' field. These cells will contain the data that the user can choose from. Type in a single cell into the 'Cell Link' field. This is the cell where the user's choice will appear. Click 'OK' when you are finished.
6. Click 'Design Mode' at the top of the screen to exit the mode. This will make the combo box unable to be moved or edited. If you need to change the location or data for the box, click 'Design Mode' again, and you will be able to make the changes.

Blogger news