How to add a checkbox in excel without developer tab

July 21, 2022
3.5K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

Adding a checkbox to your spreadsheet may appear easy, but it may greatly increase your Excel capabilities. There's a lot you can do, from checklists to graphs. It does, however, begin with the checkbox. A checkbox is an interactive feature in Excel that allows you to choose or deselect options. You've probably seen it in a variety of online formats. In Excel, you can build interactive checklists, dynamic charts, and dashboards by using checkboxes.

How to insert a checkbox in excel online, 2016 and 2019

1. The developer tab should be added to your Ribbon.

2. To find the Checkbox option, go to the Developer tab and look for it.

3. Select the cell where the checkbox control should be placed, then click the checkbox.

4. To alter the wording and change the size, right-click the checkbox.

On Windows, go to File > Options > Customize Ribbon to do so. Then click save after selecting the Developer checkbox. Click Excel > Preferences > Ribbon & Toolbar > Main Tabs on an iOS device. Then, tick the Developer box and save your changes. There are a few more steps to view the checkbox option on Windows. Click Insert under the Developer tab, then the checkbox symbol under Form Controls.

How to format a checkbox in excel

1. Toggle the format control on.

2. After making changes to the value and cell connection, click OK.

3. On Windows, right-click the checkbox and choose Format Control from the menu. Go to the Format tab on IOS and choose Format Control.

With value, there are three options:

Unchecked ; This displays an unchecked box and returns the value FALSE.

Checked; This displays a checked box and returns the value TRUE.

Mixed - The checkbox will be left empty because there is no true or false statement until an action is done.

The checkbox state (true or false) of the cell it references is contained in the cell link.

Now that you've got those parameters down, you can start customising your checkbox to your heart's content.

How to delete a checkbox in excel

Deleting is a simple two step process:

  1. Right click on the checkbox.

  2. Press Delete from your keyboard.

Note: 

To get the newest version of WPS Office, you must first access this operating interface. This was an attempt to teach you about how to add a checkbox in excel on windows. 

You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.