In this video, explore the exciting new checkboxes feature in Excel 365, which is now out of beta and available for everyone. Forget the clunky form controls of the past—these new checkboxes are sleek, easy to use, and customisable. Unlike before, there’s no need for a linked cell to manage the output; the true or false values are handled directly in the formula bar. This tutorial will walk through how to insert these stylish checkboxes, customise their colours to match your spreadsheet theme, and use them for tracking tasks. You’ll also see how to apply conditional formatting, making it easy to visualise task completion with percentage updates and dynamic formatting. Dive in to discover how these new checkboxes can transform your Excel workflow!
Ideal for those looking to streamline workflows and make more effective use of Microsoft 365 applications.
Discover how to use the new checkboxes in Excel for task tracking, including formatting, alignment, and conditional formatting without the need for cell link cells.
