How to Insert a Checkbox in Excel

Posted on

How to Insert a Checkbox in Excel – In as we speak’s tip I’ll exhibit how to use the Excel checkbox management. The checkbox permits you to allow and disable a worth, this object can be utilized for a number of spreadsheet templates.

We will have in the identical worksheet a number of checkboxes, which may be chosen on the similar time.

How to Insert a Checkbox in Excel


To raised perceive how to apply this object, we use the instance beneath:

On this instance, we’ll calculate the quantity to be paid by including a freight worth, each time we choose the checkbox.

To enter the checkbox and different controls, you should first allow the Developer tab.

To do that, click on the File tab and click on Choices.

Click on Customise Ribbon.

Choose the Developer tab.

Click on Okay.

Let’s now enter the checkbox.

Click on the Developer tab.

Click on the Insert button.

Click on the checkbox.

Click on and drag to draw the item on the worksheet.

Proper-click the verify field.

Click on edit textual content.

Change the textual content to Freight.

Now we want to configure the checkbox.

Proper-click the field once more and click on Format Management.

Within the subsequent window, we should configure a cell hyperlink for the item, in this instance, I’ll select cell A1.

Be aware: This cell can’t be used for one more course of, it ought to be restricted solely to the choice field hyperlink.

Click on Okay.

The field is configured, choose the verify field, the cell TRUE will seem in cell A1.

Unchecked seems FALSE.


Now we want to calculate the quantity to pay with freight or not.

For this, we’ll use the If operate for the reason that worth will change in accordance to the choice field.

Click on cell F7.

Enter the components: = SE (A1 = TRUE, F6 + 40, F6)

Explaining the components:

If the hyperlink cell of the checkbox ( A1 ) is equal to True then add to Subtotal ( F6 ) forty reais; in any other case, return solely the subtotal ( F6 ).

Be aware: When the hyperlink cell of the field shows True, it signifies that it’s chosen, ie the sale may have freight.

See the field is chosen and was added forty reais to the quantity payable.

With the field cleared, the payable worth returns solely the subtotal.

Till the following tip.

قالب وردپرس