Datasheet

Add a Form Control
to a Worksheet
Y
ou can add controls to a worksheet to make it
easier to enter data into a cell. Form controls can
help users who are not familiar with Excel and
can increase the accuracy of data entry by limiting a
user’s options. For example, you can add check boxes to
your worksheet so it looks like a paper form. You can
also add a list box from which users can select an entry.
Excel provides nine controls you can add to a worksheet.
You add controls by selecting the control you want from
the Forms Control menu. After you add a control, you
can adjust its size by dragging the side or corner handles.
When you add a control or right-click a control to edit,
you are in design mode. In design mode, you can modify
the properties and size of the control, but you cannot test
its functionality.
When you place a control on a worksheet, it sits on top
of the worksheet. You can size it so it appears to be
located in a cell, but controls are separate from cells and
you can place them anywhere on the worksheet. A
control can cover any portion of a cell or range of cells.
After you add controls to a worksheet, you can assign
them values. See the section, “Assign Values to a Form
Control,” for more information on assigning control
values. Form control options are located on the Developer
tab. See the section, “Introducing Macros,” to learn how
to display the Developer tab.
1 Click the Developer tab.
Note:
See the section, “Introducing Macros,” to learn how to
display the Developer tab.
2 Click Insert in the Controls group.
The Forms Control menu appears.
3 Click to select the control you want to add.
3
1
2
4
5
Add a Form Control to a Worksheet
20
4 Drag the cursor to create the control.
5 Drag the handles on the sides and corners to adjust the
size.
04_132302 ch01.qxp 7/27/07 9:20 PM Page 20