1 How to activate the Check Box-Option in the Ribbon2 How to add checkboxes to cells3 How to link checkboxes to cells4 How to use connected checkboxes and formulas5 How to create a To-Do list with check boxes and conditional formatting6 Extra: How to Lock Cells in Excel to Protect from Editing7 Extra: How to Find Duplicates in Excel and Remove Their Rows
These are members of a family of control elements called Form Controls and they are one of the ways in which you are able to easily interact with a website or an application on your computer. You may know of them as check boxes, checkmark boxes, or even just tick boxes, but they’re boxes that you can click on to add or remove a check symbol or tick in order to show that something has been selected or deselected.
Reasons to insert a checkbox in Excel
Although they might not sound like much, an Excel check box can allow you to enter simple yes/no or on/off data with a click instead of needing to select a cell and enter your data using the keyboard. This makes it easy to set up worksheets to track things like goals, assignments, or even as we will show you in this article, a shopping list. You may not have thought to add a checkbox in Excel before, but these are a simple and effective way to add functionality to your worksheets and make binary data easy to set up and read.
How to activate the Check Box-Option in the Ribbon
How to add checkboxes to cells
How to link checkboxes to cells
How to use connected checkboxes and formulas
How to create a To-Do list with check boxes and conditional formatting
Extra: How to Lock Cells in Excel to Protect from Editing
Even if you aren’t sharing a spreadsheet, learning how to lock cells in Excel can save you a lot of trouble. No matter how proficient you are with the software, it’s easy enough for you or a pet to lean on a key and break your formulas. You’ll find checkboxes under Form Control under the Developer tab, which you will enable in the Customize Ribbon options.
Note: you may need to click outside of the selection box of the checkbox – in this example clicking on the right-hand area of the cell – as its selection box may block your mouse click.
Extra: How to Find Duplicates in Excel and Remove Their Rows
Creating duplicate content is so common that Microsoft’s spreadsheet software has an in-built Remove Duplicates tool. This isn’t always the best way to delete duplicate rows in Excel, however – sometimes the find and replace or advanced filtering options will be more efficient.
