You can group, copy, resize, or format controls on a worksheet form.

Notes: 

  • You cannot combine Form controls or ActiveX controls with Drawing Tools or SmartArt Tools objects (such as Shapes and SmartArt graphics) in the same group selection.

  • Make sure the Developer tab is visible on the ribbon. For more information, see Show the Developer tab. Then ensure that Design Mode has been enabled. To do this, click Developer > Design Mode (in Controls group).

    Design Mode on the ribbon
  • When you’re done working with controls, turn off Design Mode.

Click the selection border of the control.

The control border for a Form control appears as a dotted pattern and a series of sizing handles:

Form control border

The control border for an ActiveX control appears as a series of sizing handles:

ActiveX control border

Using the Selection Pane makes it easier to select one or more objects, and also to show, hide, or change the order of objects.

  1. On the Home tab, in the Editing group, click Find & Select.

    Find & Select on the ribbon

  2. Do one of the following:

    1. To select objects that are hidden, stacked, or behind text, click Select Objects, and then draw a box over the objects.

    2. To open a task pane in which you can select, multi-select, show, hide, or change the order of objects— click Selection Pane, and then click the options that you want.

Tip: To select controls using a mouse, press and hold the CTRL key until the controls are selected.

First, click the selection border of the group.

The group selection border appears as a series of sizing handles:

ActiveX control border

Then, click the control that you want to select inside the group.

First, click the selection border of the group.

The group selection border appears as a series of sizing handles:

ActiveX control border  

Then, press and hold the CTRL key until the controls are selected.

Click the selection border of the group, and the group selection border appears as a series of sizing handles:

ActiveX control border

Do the following to select a control that is hidden or under other controls:

  1. Select the control that is on the top layer.

  2. Press TAB to cycle forward or SHIFT+TAB to cycle backward through the controls.

On the Home tab, in the Editing group, click Find & Select, and then do either of the following:

  • Click Select Objects, and then use the mouse pointer to draw a rectangle around the objects that you want to select.

  • Click Selection Pane, and then use the pane to select one or more objects.

Do either of the following:

  • To cancel the selection of one or more controls, click anywhere outside the control, set of selected controls, or group border.

  • To cancel the selection of one control at a time in a set of selected controls, hold down CTRL and click the control.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.