Checkboxes have just got a lot better.
If you're an Excel long-timer, there's a good chance you're already aware of the existing ones. You might have used them for to-do lists, task management, or interactive dashboards. However, you'll probably agree they are rather frustrating to work with.
They are not easily accessible. You must go to File > Options > Customise Ribbon and enable the Developer tab. Here, you can then select the Check Box form control from the Insert dropdown menu to draw on the worksheet grid.
They require a designated cell link reference to determine the checkbox’s state as TRUE or FALSE, which is found in the Format Control window. This is necessary as formulas cannot directly reference the checkbox.
They are only compatible with Excel for desktop, so you can't use them on the web or mobile app.
They are pixelated when zooming in, which really does make them look antiquated. Look how jagged that tick is!
Their colour cannot be changed, either statically or through conditional formatting. You can only change the background and border colour.
They cannot be housed in cells, so they sit merely on top of the grid, making them detached from everything cell-based. This can mess up the visual appearance of your worksheet by making things like alignment more difficult, especially if you require many checkboxes.
They cannot be resized. You can only adjust the size of the container a checkbox is housed in, which is a bit pointless!
Thankfully, an update started rolling out to Microsoft 365 Insiders a few months ago, allowing you to take advantage of the new type.
If you're not already an Insider, it's well worth becoming one if you're desperate to try out new features like this! Go to Microsoft's webpage to find out more information.
It's fair to say there are many similarities to Google Sheets' checkboxes, which have been lauded for their superiority over the years. However, Excel's new ones not only match them but have a few more bells and whistles!
They are easily accessible — the Checkbox button is found on the Insert tab. Clicking it inserts a checkbox in the active cell or in each cell of a range.
They can be resized by changing the font size. You probably won't need a ginormous checkbox, but it's nice to know it's possible!
They can be any font colour. This means you can choose from up to 16 million colours in Excel's palette!
They don't become pixelated if you increase their size or when zooming in. Perfect for viewing on high-res monitors!
The TRUE or FALSE value is built into the same cell as the checkbox, so there's no separation between the two anymore.
The spacebar can be used instead of the mouse to toggle between the TRUE and FALSE states.
If you delete a checkbox, it doesn't go away entirely, as hovering over it causes a 'ghost' checkbox to temporarily appear. Clicking on it again then reactivates the permanent one.
One of the best things is how the new checkboxes can be combined with conditional formatting to help visually enhance our worksheets.
In this to-do list example, the checkbox and text are red for uncompleted tasks, whereas they're green for completed ones along with struck-out text.
They also serve as a user-friendly filter feature, which you can use on a dataset.
Or, how about to filter a chart?
There's no doubt the new checkboxes are a much-welcome addition to Excel. What's certain is they will be used by far more people than the current ones are, thanks mainly to their accessibility and compatibility. Moreover, you've already seen a glimpse of their versatility, so it'll be interesting to see the innovative uses for them going forward.
What will you be using the new checkboxes for?
For more Excel tips and tricks like this, check out our Video Tutorials page.
Conversation
As you comment, let's keep the discussion friendly and respectful to add value to the conversation.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere. uis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.