Add checkboxes to your Excel lists

Do you want to make a list of your tasks for the day? Do you want to put together a spreadsheet to check who attended a meeting and who didn't? That's what checkboxes are for, and this functionality is already available in Microsoft Excel.

WHAT ARE CHECK BOXES?

Check boxes are those little squares that are checked or unchecked inside a cell.

They represent the logical values TRUE (box with an accent) or FALSE (box without an accent).

WHAT ARE THEY FOR?

You can use the checkboxes to:

• Turn conditional formatting on/off

• Track completed/uncompleted tasks

• Use as an indicator to count, sum, or average columns using conditional functions ( section 6 of the "Excel for Work Course" )

• Replace the slightly "ugly" display of the words TRUE and FALSE with a checked or unchecked box ( section 5 of the "Excel for Work Course" )

WHEN WILL THIS FEATURE BE AVAILABLE?

This feature is available since late 2024! When your version of Microsoft Excel is updated, you will find the option to insert checkboxes on the ribbon under Insert > Cell Controls > Checkbox. Below you can see what it will look like:

Learn more about Excel in the "Excel for Work Course" on Udemy !