When the cell containing the drop-down list is selected, you'll see a down arrow button to the right of the cell. Enter a Title and an Input message and then click the 'OK' button. Make sure the 'Show input message when the cell is selected' box is checked. You may select the 'Combo Box' and drag any of the small squares in the middle of the boundaries or circles in the corners to change the size. Click on the Excel Sheet at a location where you want to place the 'Combo Box'. Go to the Developer tab in the Excel Ribbon - click Insert - click on 'Combo Box' under 'Form Controls'. Do any of the following: Add or remove a picture border.
Click Shape Format, and then click the arrow next to Shape Outline. Select the shape or text box to which you want to add, change, or remove a border.
