Group Box in Excel

In this lesson you will learn how to create and configure frame in Excel.

 

Group box could be quite important for you when you use many controls in your controls. Group box groups controls such as radio button or checkbox.

Inserting Group Box:

To insert group box to the spreadsheet in Excel first to to the Developer tab, in the Controls group. Click Insert, and then under Form Controls, click Group Box.

Insert Group Box

Click the worksheet location where you want to insert the group box.

Group Box

To set the control’s properties, right-click the icon, and then click Format Control.

Format Control

Example of group boxes in Excel:

Group Box with a check box.

Example Checkboxes

Group Box with option buttons.

Example Option buttons

Template

You can download the Template here – Download