Office
Sign in

Select or deselect controls on a worksheet

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, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×