Datasheet

20
2
3
5
4
1
4 Click and drag the mouse pointer to
create the control.
5 Click and drag the handles on the
sides and corners to adjust the size.
1 Click the Developer tab.
2 Click Insert.
The Form Controls menu appears.
3 Click to select the control you want.
Add a Form Control to a Worksheet
Y
ou can add controls to a worksheet to make it
easier to enter data. Form controls can aid users
who are not familiar with Excel and can increase
the accuracy of data entry by limiting the options a user
has. For example, you can add check boxes to your
worksheet so your worksheet looks like a paper form.
You can also add a combo 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 Form Controls menu. After you add a control, you can
adjust its size by dragging the side or corner handles.
When you add a control or when you right-click a control
twice and then click the control, 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. You can
place controls anywhere on the worksheet. A control can
cover any portion of a cell or range of cells.
After you add a control to a worksheet, you can assign it
values. See the next section, “Assign Values to a Form
Control,” to learn how. Form control options are located
on the Developer tab. See the section “Introducing
Macros” in this chapter to learn how to display the
Developer tab.
Add a Form Control
to a Worksheet
03_591598-ch01.indd 2003_591598-ch01.indd 20 6/11/10 1:41 PM6/11/10 1:41 PM