Insert checkbox in Excel
Related Videos: How to Add Check Boxes In MS Excel Sheet (Easy) (May 2024).
You can use a checkbox that you insert in your Excel document as a form element or as a control element. We show you exactly how to proceed in order to integrate this "check box" by means of these instructions.
Simply tick off: Checkboxes in Excel make forms clear
Latest videos
Insert checkbox in Excel: Activate developer tools
Form elements: Select the checkbox symbol
Edit the check box text
To align to the grid
In the standard Excel setting, you do not have direct access to the "Checkbox" button. To do this, you must first activate the “Developer” tab in the ribbon:
- In an Excel worksheet, click on "File" in the top left and then on the bottom entry "Options".
- Then a dialog box opens in which you click on the entry »Adjust ribbon« on the left side. In the field on the far right, check the box »Developer tools« to activate it as a new main tab. Confirm with OK".
- If you now in any Excel form in which you want to insert a checkbox. Then open the "Developer" tab and select "Paste" from the context menu.
- You now have various tools to choose from, grouped by form elements and ActiveX controls. Activate a checkbox for your form by clicking on the checkbox symbol (checkbox with tick) under »Form elements«.
- If you now move your mouse into your Excel document, the mouse display changes into a plus sign. With a click in the upper left corner of a cell, place a checkbox there.
- If you now move the mouse over the cell with a checkbox, you can right-click to open the context menu. Using this menu, you can, for example, adjust the text of the cell and use "Format controls" to assign a cell in which you want to see whether the checkbox is checked or not.
- Next, adapt the checkbox to the line. To do this, select "Formatting" in the menu and click on the small arrow next to "Align". Select "Align to grid" here.
- You can easily change the size of the border of the checkbox by dragging the small corner points. If you want to insert several checkboxes in your table, you do not have to repeat the whole procedure every time. Check the box and use the Copy & Paste function.
This practical tip relates to the Office 365 Home version of Excel. On our "Excel theme page" you will find even more tricks and tricks on how to make working with Excel even more efficient. For example, we explain which key combination you use to create an inequality sign in Excel.