Microsoft Office Tutorials and References
In Depth Information
Use Dialog Box Controls to Input Data
Chapter 1: Making Excel More Efficient
Excel adds the control to
6 If the control comes with
a text label, right-click the
7 Click Edit Text.
Note: You can also double-click the
Excel opens the label text
8 Type the name you want
to use for the control.
9 Click outside the control.
Excel removes the
selection handles from
Note: To select the control later on,
hold down Ctrl and click the control.
To use the worksheet form controls, you
must customize the Excel Ribbon to
display the Developer tab. Right-click
any part of the Ribbon and then click
Customize the Ribbon. The Excel Options
dialog box appears with the Customize
Ribbon tab displayed. In the Customize
the Ribbon list box, click to select the
Developer option, and then click OK.
Did You Know?
When you are dragging the control on the
worksheet, you can make the control’s
border snap to the worksheet’s cells by
holding down the Alt key as you drag. If
you want the control to be a perfect square,
hold down Shift as you drag. If you want
the control to be centered on the spot
where you start dragging, hold down Ctrl as