As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Adding Check Boxes in Excel: A Step-by-Step Guide

In Excel, incorporating a check box involves placing an object within a worksheet, enabling users to toggle options on or off. These boxes are utilized when choosing from a list of options, displaying a tick when selected and removing it when deselected.

To insert a check box in Excel, follow these steps

  1. Navigate to the Developer tab, access the Controls group, select Insert, and then choose Check Box under Form Controls.
  2. Click the desired location within the worksheet to place the check box.
  3. Modify the check box name by selecting it, then clicking Edit Text in the Controls group.
  4. To assign a macro, choose the check box, click Assign Macro in the Controls group, pick the intended macro, and click OK in the Assign Macro dialog box.

For swift addition of multiple check boxes simultaneously

  1. On the Developer tab, in the Controls group, select Insert, and then opt for Multiple Check Boxes under Form Controls.
  2. Click the worksheet area where the check boxes should be inserted.
  3. Adjust the check box name by selecting it and using the Edit Text option in the Controls group.
  4. To assign a macro, choose the check box, click Assign Macro in the Controls group, select the intended macro, and click OK in the Assign Macro dialog box.

For relocating or resizing a check box

  1. Select the check box intended for movement or resizing.
  2. When the cursor changes to , either drag the check box to a new location or resize it by dragging a sizing handle.

To delete a check box

  1. Click the check box to be removed and press DELETE.

Managing check box size and appearance

Upon insertion, a check box in Excel adheres to the current Windows settings for its size and appearance. To alter these attributes, adjust the Windows settings.

To modify the check box size

  1. Access the Start menu and click Control Panel.
  2. Within Control Panel, navigate through Appearance and Themes and select Display.
  3. On the Appearance tab, under Item, choose Advanced.
  4. In the Advanced Appearance dialog box, under Item, select Check Box.
  5. Adjust the size by entering or selecting a value in the Size box.
  6. Choose a color, font, font style, and font size for the check box.
  7. Confirm changes by clicking OK twice.

To adjust the check box's appearance

  1. Open the Start menu and click Control Panel.
  2. Within Control Panel, navigate through Appearance and Themes and select Display.
  3. On the Appearance tab, under Item, choose Advanced.
  4. In the Advanced Appearance dialog box, under Item, select Check Box.
  5. Select a picture for the check box within the Picture box.
  6. Adjust the size, color, font, font style, and font size for the check box.
  7. Confirm changes by clicking OK twice.