Excel: Create a Checkbox-Driven Filter (Using the NEW Checkbox Feature)

Microsoft added a new feature to Excel recently - the ability to add a checkbox into a cell. Yes Excel can already do this but this new method is an improvement, offering more functionality and making it easy to insert multiple checkboxes, apply formatting, respond to formulas and more.
At the time of recording (Nov 2023) it’s only available to users on the Beta Insiders Channel but hopefully Microsoft will, in time, roll it out to everyone.
There’s plenty of use cases for this new feature and this video focuses on one - how to create a checkbox-driven filter on a dashboard.
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/u14znsznzjt99cr...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋‍♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #checkbox #filter #dashboard

[@pandamonium9834]

We don’t have that version as far as I know, but that’s a really good one so thanks for sharing Mike

[@ianrobertson5128]

Hi Mike. I have installed the Beta version of Excel for Mac however the checkbox is not displayed on the insert menu tab. Do I need to install it manually? Version: 16.80 (23102918)

[@MikeThomas67]

@ianrobertson5128 Have a look at the accompanying blog post. It explains all: theexceltrainer.co.uk/create-a-checkbox-style-filter

[@ianrobertson5128]

I have the "Cell Control" tab in the "Ribbon & Toolbar" setup, but it doesn't show up on the Insert tab. Maybe the next rollout will fix the issue. Not sure why Microsoft only sends it out to some people and not others, Frustrating!