How to insert checkboxes in microsoft Excel

Insert a check box or check box in a Microsoft Excel File is a great way to improve interactivity. To the example, User of at Excel Spreadsheet can interact with the check box to indicate positive or negative decisions. This is useful when the table is used to activate a setting or to reach a conclusion.

Inserting a check box in a Microsoft Excel File is very simple. However, this requires the Developer tab on your Excel Ribbon. The Developer tab is common to all versions of. available Excel (2007, 2010, 2013, 2016, 2019 and Office 365). How to access it to include checkboxes in Excel.

How to customize that Excel Ribbon to display the developer tab

The Developer tab provides access to advanced features and capabilities of Excel. However, the Developer tab is always hidden by default. To customize the ribbon to show the Developer tab:

Step 1: Start the Microsoft Excel App.

Step 2: Place the mouse pointer on the Excel Ribbon and right click.

Step 3: From the options listed, select Customize the Ribbon. This action starts the dialog box with the label Excel Options.

Check box in Microsoft Excel Insert step 3

Step 4: From the options on the left of the Excel In the Options dialog box, select Customize the Ribbon.

Check box in Microsoft Excel Insert step 4

Step 5: Far right of the Excel In the Options dialog box, under the Customize the Ribbon box, select the drop-down menu.

Check box in Microsoft Excel Insert step 4

Step 6: Select Main Tabs from the drop-down list.

Check box in Microsoft Excel Insert step 5

Step 7: In the list of options that appear, scroll to the Developer option.

Check box in Microsoft Excel Insert step 6

Step 8: Check the box next to the Developer option and click OK. The Developer tab should appear on the page Excel Ribbon as one of the tabs.

Check box in Microsoft Excel Insert step 7

How to add a check box in. a Excel Using the Developer Tab

With the Developer tab now visible on the Excel Ribbon you can now easily insert a check box. Here are the steps you should follow to do this:

Step 1: Click the Developer tab on the ribbon in your Excel Window.

Check box in Microsoft Excel Insert step 8

Step 2: From the options listed in the Controls group, click the drop-down menu under Insert.

Check box in Microsoft Excel Insert step 9

Step 3: Under the menu titled Form Controls, move your cursor over each icon until you see the name Check Box (Form Control). Select the icon.

Check box in Microsoft Excel Insert step 10

Step 4: After clicking the check box icon, your cursor should change to +. Click with the cursor on any part of your worksheet that the check box inserts automatically.

Check box in Microsoft Excel Insert step 11

Step 5: Once the check box appears, the default name you see is the check box plus the number of the check box. If you want to change the name of the check box, place the cursor over the name of the check box to rename it.

Check box in Microsoft Excel Insert step 16

If the purpose of the check box is to present information visually, you can stop here. However, if you want the check box result to produce a different result, you need to know how to link the check box.

How to format the check boxes in Microsoft Excel

The check box in Microsoft Excel can also be used in formulas or to call up certain actions. To do this, the check box must be linked to other cells in Excel. This is how it works:

Step 1: Right click on the newly added check box, then select Format Control. You can also use the keyboard shortcut Ctrl + 1 to launch the Format Control dialog box.

Check box in Microsoft Excel Insert step 12

Step 2: In the Format Control dialog box, select the Control tab.

Check box in Microsoft Excel Insert step 13

Step 3: Under the group for Value, you should see three options titled Unchecked, Checked Mixed. To find the most suitable value for you, present each option as follows:

  • Not marked: This ensures that the check box is cleared when you use the Excel File.
  • Checked: This will ensure that the box is checked when you use the Excel File.
  • Mixed: This will ensure that the check box is grayed out.

Check box in Microsoft Excel Insert step 14

Step 4: Next to the Cell Link option, enter the details of the cell you want to link to your check box and select OK.

Check box in Microsoft Excel Insert step 15

The result shown in the linked cell of the check box can be used in other Microsoft. be used Excel Formulas.

Apply a format to multiple check boxes in Excel

Using checkboxes in Microsoft Excel can make your spreadsheet look appealing and help automate certain actions. To the example, you can apply a format to multiple checkboxes in Microsoft Excel with macros.

Related Posts