Page 213 - Excel Data Analysis

11 537547 Ch10.qxd 3/4/03 12:03 PM Page 199

FORM CONTROLS 10

When designing a form on a worksheet, You can remove controls from a worksheet at any time.
you may not want the grid lines outlining To remove a control, right-click the control to select it
each cell to show. To remove the grid lines and then click Cut from the menu that displays. Excel
from the worksheet display, click the removes the selected control from the worksheet.
Toggle Grid button ( ) on the Forms
toolbar. You can click the button to switch You can place the Forms toolbar at any location in the
between displaying and removing the grid Excel window. If you want to dock the toolbar at the top
lines. The Toggle Grid button only removes of the window with the other toolbars, click and drag the
the grid lines that display when you view toolbar to the desired location. You can also dock the
the worksheet in Excel. It does not affect toolbar on either side of the window or at the bottom.
any borders that you have applied to the You can also leave the toolbar sitting undocked anywhere
worksheet. on your screen.

■ The form control appears ■ You can repeat steps 2 to 4 ■ The added form controls ■ To cancel design mode,
at the specified size. to add additional controls to appear in the specified click a cell of the worksheet.
the worksheet, as desired. locations on the worksheet.
› Drag the control to the
desired location on the form. ■ You can place a control in
design mode to modify its
properties or resize it by
right-clicking it.
199