⋮  

How to Add Checkboxes in Microsoft Excel

Submit

Checkboxes are a great way to track productivity, indicate choices, vote for changes, etc. If you are creating spreadsheets and you wish to add checkboxes to them, you can easily do so without issues. This tutorial will address this and show you how to add checkboxes in Microsoft Excel. These little boxes are very useful and make tasks quicker.

Add Checkboxes in Microsoft Excel

The first thing you should do is add the developer tab in the excel ribbon, and from here, you can quickly add checkboxes to excel.

Developer Tab

To add the Developer tab, follow the steps below:

Step-1: Open Microsoft Excel.

Step-2: Hover your cursor on the Excel ribbon and right-click. Select Customize the Ribbon.

Add Checkboxes in Microsoft Excel

Step-3: Ensure that you are in Customize Ribbon tab from the left pane and ensure that the Main tabs option is selected from the Customize the Ribbon drop-down menu.

Add Checkboxes in Microsoft Excel

Step-4: Locate the Developer checkbox and select it. Now press OK.

Developer Tab

Add Checkboxes in Microsoft Excel Using Developer Tab

  1.  Click on the Developer tab.
    Select Developer Tab
  2.  In the Controls section, locate Insert and click on the small downward arrow.
    Add Checkboxes in Microsoft Excel
  3.  Select the Checkbox icon.
    Add Checkboxes in Microsoft Excel
  4.  Your cursor will change into a plus icon, and you can use it to add a checkbox anywhere you like. Click the cursor and drag it to ‘draw’ the checkbox.
  5.  Now change the default name ‘Check box 1’ and name it anything you like. You can even leave it blank.
    Add Checkboxes in Microsoft Excel

If you have any more questions, you can ask us in the comments below. If you have other tips that you use, share them with us.

Submit