19 Ways to Use Excel’s NEW Checkboxes Feature

🔍 Discover 19 Innovative Uses for Excel's New Checkboxes Feature! Excel's latest update introduces checkboxes, offering a powerful new way to organize, track, and manage your data. From to-do lists to project management and beyond, check out these 19 creative ways to make the most of this versatile tool!

🔗LINKS


Related Content:

00:00 Introduction
00:18 Simple Checklist
01:08 Conditional Formatting for a List
02:09 IF Formula
02:43 Highlight Entire Row
03:40 Filter to Compare Rows
04:10 Format Checked Items
04:35 Show Details on a Table
05:33 Show Details on a Chart
05:50 Counting Checkboxes
06:23 Attendance Tracker
06:47 Progress Chart
07:32 Excel Tables
07:57 Reveal List and Invisible Reveal
08:32 Calendar Chart
09:00 Interactive Calendar
09:20 Reset Button
09:53 Select All Button
10:04 Toggle Chart Series
10:41 Tips for Using and Formatting Checkboxes
10:52 Deleting Checkboxes
11:14 Availability: Versions of Excel with Checkboxes
11:41 Backward Compatibility

[stuartcolquhoun-ms]

Yes, I would love to see the let/expand formula for the invoice details, thanks. Would be great

[MattyauRoss]

Do another video on that long formula plz

[TonyRandall-ce]

Yes please do a video on this long formula so I can do this for jobs and what was spent on that job.

[jodileathatsme]

This is fabulous information and SO HELPFUL! Thanks! I would definitely like to see a full video on the Inv Details formula (LET, XMATCH, VSTACK), please! Thanks!

[karolinab]

Thank you, Jon! Great examples! 😊 Do explain in detail how you get tooltip kind of effect when you tick the data, please.

[GrainneDuggan_Excel]

thanks Jon for this very thorough explanation of the uses for checkboxes!

[IvanCortinas_ES]

I've seen it in detail. Spectacular. It's amazing how many doors have been opened. Thanks for contributing so many ideas, Jon.

[shamshadjalali]

This was one of yet very useful conditional formatting. thanks

[PaulEBrownbill]

Excellent thanks, don't have checkboxes yet in my work 365 version, but hopefully soon

[BenSwarner]

Good video! Lots of great ideas. Would love a video on the let function. That was the first time I’ve seen that one.

[ianl]

New Checkboxes was the reason I signed up to Beta last year. I haven't watched the video in it's entirety yet. I paused at #6 (Filter to Compare Rows) especially the advanced part where I can highlight the following row. I downloaded your file so I could check out the complete Conditional Formatting. I found the perfect spreadsheet I'm constantly updating that would be perfect for. So glad it works as planned. 👍

[cis]

As usual great video! One question: is it possible to add a table row that has a checkbox (365) using an input form?

[IvanCortinas_ES]

Excellent gift, Jon. Highly professional, as always. To review calmly and have a good afternoon. Thanks for sharing.

[twarren]

Jon, This was a great instructional video. Please do a video on creating the detail list. This was very impressive !

[josilhus]

Really would appreciate a video about the formula in the 4:45 example . It's amazing and give a professional touch to the report

[TinfoilHat]

Great info. I would be very interested to see how you could add line items by checkbox from a different sheet. For example, if sheet 1 contained a report template, and sheet 2 contained a table of data, with check boxes by each row, how would you include the checked rows into the report in sheet 1, without including blank rows?

[thiagobezerra]

Excellent video. Wish checkbox could be used for timestamp instead of using macro for that.

[ErikNolander]

Hi Jon, thanks for a great video! I would also like a tutorial on the filter table formula you showed.

[williamarthur]

Yes please re filter vstack etc . I've been waiting for these check boxes for a while, I koow you could always do them but often they were a nice idea but not worth it if time was constraint and there were moth important things to do. great vidieo.

[lpanades]

Wanna learn more, fantastic resource.