Resize or format a control on a worksheet

To create a professional looking appearance for a worksheet form, you should provide a consistent format to all controls and objects, and size them appropriately.

What do you want to do?


Resize a control

You can resize a control by dragging its sizing handles or by entering measurements in the Format Control dialog box.

  1. If one or more controls is an ActiveX control:
    1. Make sure that the Developer tab is available.

ShowDisplay the Developer tab

  1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

 Note   The Ribbon is a component of the Microsoft Office Fluent user interface.

  1. Make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode Button image.
  1. Select the control that you want to resize.

For more information, see Select or deselect controls on a worksheet.

  1. Do one of the following:

Resize by using the sizing handles    

  1. Position the pointer over one of the handles (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.).

Object with selection handles

  1. Do one of the following:
  • To increase or decrease the size in one or more directions, drag the mouse away from or toward the center.
  • To keep the center of a control in the same place, hold down CTRL while you drag the mouse.
  • To maintain the control's proportions, hold down SHIFT while you drag the mouse.
  • To maintain the proportions while keeping the center in the same place, hold down CTRL and SHIFT while you drag the mouse.
  1. Release the mouse, and then release CTRL or SHIFT.

Resize by entering measurements    

  1. Right-click the selection, and then click Format Control.
  2. On the Size tab, enter measurements for the height and width of the control, or click the up or down arrow keys to move the height and width.
  3. To maintain the control's proportions, select the Lock aspect ratio check box.

 Note   The Reset button (which resets the original height and width), the Rotation text box, and the Relative to original picture size check box are not available.

Top of Page Top of Page

Format an ActiveX control

  1. If one or more controls is an ActiveX control:
    1. Make sure that the Developer tab is available.

ShowDisplay the Developer tab

  1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

 Note   The Ribbon is a component of the Microsoft Office Fluent user interface.

  1. Make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode Button image.
  1. Select the control that you want to format.

For more information, see Select or deselect controls on a worksheet.

  1. To set the format properties for the control, on the Developer tab, in the Controls group, click Properties Button image.

 Tip   You can also right-click the control, and then click Properties.

The Properties dialog box appears. For detailed information about each format property, select the property, and then press F1 to display a Visual Basic Help (Visual Basic Help: To get Help for Visual Basic, point to Macro on the Tools menu, and then click Visual Basic Editor. On the Help menu, click Microsoft Visual Basic Help.) topic. You can also type the property name in the Visual Basic Help Search box. The following section summarizes the format properties that are available.

Summary of formatting properties

 Note   Each ActiveX control has a different subset of the following formatting properties.

If you want to specify Use this property
The foreground color. ForeColor (Form)
The background color. BackColor (Form)
The background style (transparent or opaque). BackStyle (Form)
The color of the border. BorderColor (Form)
The type of border (none or single-line). BorderStyle (Form)
Whether the control has a shadow. Shadow (Excel)
The visual appearance of the border (flat, raised, sunken, etched, or bump). SpecialEffect (Form)

Top of Page Top of Page

Format the colors and lines of a Form control check box or option button

  1. Select the control that you want to format.

For more information, see Select or deselect controls on a worksheet.

  1. Right-click the selection, and then click Format Control.
  2. On the Colors and Lines tab, do one or more of the following:
    • To change the color, select a color from the Color list box.
    • To find more colors, create your own colors, or adjust transparency, click More Colors.
    • To adjust the gradient, texture, and pattern, or add a picture, click Fill Effects.

Top of Page Top of Page

Format the font, margins, and alignment of a Form control button

  1. Select the control that you want to format.

For more information, see Select or deselect controls on a worksheet.

  1. Right-click the selection, and then click Format Control.
  2. On the Font tab, select the font type, font style, font size, other formatting options for the selected text.

For the Size value, you can type any number between 1 and 1638. The sizes available in the Size list depend on the selected font and the active printer. Select the Normal Font check box to reset the font, font style, size, and effects to the Normal (default) style.

  1. Click OK.
  2. Right-click the selection, and then click Format Control.
  3. On the Alignment tab, select the text alignment, direction, and orientation options that you want, and then click OK.
  4. Right-click the selection, and then click Format Control.
  5. On the Margins tab, select the internal margin options that you want, and then click OK.

Top of Page Top of Page

Format a Form control so that it has a 3-D appearance

 Note   Because the Form label control cannot be formatted to appear with 3-D shading, and the Form button control can appear only with 3-D shading, the 3-D shading check box is not available for either control in the Format Control dialog box.

  1. Select the control that you want to format.

For more information, see Select or deselect controls on a worksheet.

  1. Right click the selection, and then click Format Control.
  2. On the Control tab, click 3-D shading.

Top of Page Top of Page

 
 
Applies to:
Excel 2007