Question

Excel: Insert a checkbox - this is how it works

Answer 1

How to use a checkbox in Excel
1st step:
2nd step:
3rd step:
4th step:
5th step:
6th step:
7th step:
8th step:
9th step:
Step 10:
Video
quick start Guide

---

With checkboxes you can easily tick off tasks in Excel. You can find out how to insert the checkboxes here..

A checkbox, or checkbox, can be used in Excel to tick off the contents of cells and to mark them as done or true. It doesn't matter whether you are doing this for your shopping or to-do list or you need checkboxes for a survey - with our instructions, inserting and using the checkboxes is very easy.

How to use a checkbox in Excel

Follow our step-by-step instructions , the quick start guide or the explanatory video .

1st step:

First, you need to add the developer tools to the ribbon. To do this, click on the " File " tab at the top left .

2nd step:

Now select " Options " on the left .

3rd step:

In the new window, switch to the " Customize Ribbon " category on the left . Under " Main Tabs " look for " Developer Tools " and tick it. Then click OK .

4th step:

Now switch to the newly added tab " Developer " at the top .

5th step:

Click on " Insert " and under " Form Controls " select the third icon from the left, the little check box .

6th step:

Now click on a cell in which you want to insert the checkbox.

7th step:

To edit the text of the check box, right-click it, then choose Edit Text . You can now enter any text or leave it out entirely.

8th step:

To adapt the checkbox to the cell, right-click again , switch to the " Format " category at the top and click on the symbol next to " Move forward layer ". Now select " Align to grid " from the menu .

9th step:

Now drag the border of the check box at the points to the desired position in order to adapt it to the cell.

Step 10:

If you now mark the box again with the help of a right-click and press the [Ctrl] + [C] keys , you can easily insert the checkbox into other cells with [Ctrl] + [V] without having to use the Having to insert ribbon.

Video

quick start Guide

1. Click on the " File " tab at the top left and then select " Options " at the bottom left .
2. Now switch to the left to " Ribbon adjust " and set right a hook at " Developer Tools ". Then click OK .
3. Now go to the Developer Tab at the top and click Insert . Now under " Form controls " select the third icon from the left, the check box .
4. Click on a cell to insert the checkbox.
5. Make a right click on the check box and select " Edit Text " to the text of the checkbox to adjust.
6. Take a again right-click on the check box and click on the top of the ribbon, click " Format ". Then click the icon next to "Bring Layer to Front " and select " Snap to Grid ".
7. Now use the dots to drag the border of the check box to the size and position you want it to be.
8. If you mark the checkbox again with a right click , you can copy and paste it with the help of [Ctrl] + [C] and [Ctrl] + [V] .

---