19 Ways to Use Excel’s NEW Checkboxes Feature

[@stuartcolquhoun-m1s]

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

[@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.

[@ExcelCampus]

Glad you liked it! 😀

[@TonyRandall-c1e]

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

[@ExcelCampus]

Great idea on using this to see expense details for jobs/projects. I'll try to include that example in the follow up video. Thanks Tony! 👍

[@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

[@MattyauRoss]

Do another video on that long formula plz

[@GrainneDuggan_Excel]

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

[@ExcelCampus]

You're welcome! 😀

[@twarren3685]

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

[@ExcelCampus]

Thank you for your feedback! 😀

[@josealvesferreira1683]

Congratulations, very good

[@PaulEBrownbill]

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

[@karolinab9749]

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

[@DanieleGaetanoSciuto]

Hi, great video, all very interesting and useful. It would be nice if you made a video explanation of the part with the Check Box that displays the details by putting the flag on the check box! This would be very nice. Thanks

[@chrism9037]

Great video Jon!

[@nicflanagan6662]

Excellent ❤

[@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.

[@ExcelCampus]

Thanks Ben! Will do. 🙂

[@lpanades]

Wanna learn more, fantastic resource.

[@shamshadjalali8445]

This was one of yet very useful conditional formatting. thanks

[@ExcelCampus]

Glad to hear that! 😀

[@williamarthur4801]

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.

[@ExcelCampus]

Thanks William! Will do!

[@IvanCortinas_ES]

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

[@ExcelCampus]

Thanks Ivan! Hope you have a good one too. 🙂

[@Excelambda]

Super cool video!! Remember the "ghost" state of early checkboxes, when we deleted them, that they were still there, if we hovered the mouse over them? That functionality had the advantage of being able to use it for tri state scenarios. On ghost state (still there but faded) they are blanks. So the tri state: blank, true, false. Can be handy for some scenarios like :not arrived yet, arrived, left or maybe, yes, no..etc. Now to get them in the ghost state( blank state) , choose a range, insert, backspace all the way first cell, Ctr+Enter. Their border will be a little bit faded. So, before , deleting them triggered ghost state, now deleting them deletes them completely but backspace and enter wll get them in that sometimes useful "ghost" state. ✌ formula example: =IFS(ISBLANK(range),"Maybe",range=FALSE,"No",1,"Yes")

[@ExcelCampus]

Thanks for sharing! That's a cool trick!! I'm just wondering if it's a bug that will eventually be fixed/removed. So I'm not sure I would rely on it for long term solutions. I was a fan of the ghost state, but I also saw how it was confusing for users.

[@Excelambda]

@@ExcelCampus You're welcome!! Me too, fan of ghost state (now is better called faded state) and I was so sad they removed it, and then I found the trick with backspace. Will see. I think it's on purpose. Who wants to use it it's there. ✌🙏

[@abdsab78]

Truely love it...

[@mrstefanpersson]

Great video as usual! Is it possible to protect the sheet and the checkboxes, but still be able to use the checkboxes? If so, how do i do that?

[@maciejkopczynski55]

If the checkboxes are not defined as “protected cells” in cell properties then you will be able to use toggle them off and on.

[@thiagobezerra4841]

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

[@ExcelCampus]

Thanks Thiago! The checkbox actually can be used for a timestamp without a macro. You do have to turn on iterative calculation in the workbook, so it’s a bit of a workaround. We’ll be publishing a short video on the setup next week.

[@ryanmac3134]

Man I could have used this five years ago for sure. This would have made some work so much easier. Great vid man!

[@cmcull987]

Jon, I have a friend who wants to catalog lots of data (books, vacation, chores, household goods, etc.). He thinks Access is the way to go but I'm suggesting Excel for him. Could you explain the difference between the two programs and help me help him better understand why Excel is best for his situation? BTW, I always enjoy your videos, they are a big help.

[@KeithAul]

Can you create a tutorial on how you accomplish the show details example at timestamp 5:05?

[@ErikNolander]

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

[@rajeevgosavi4514]

Great Tutorial with almost everything covered. Shall be very usefull for day to day work of inspection. Thanks John, GOD BLESS.

[@ExcelCampus]

You're welcome! 😀

[@ccapple3839]

@stuartcolquhoun-m1s 2 天前 Yes, please share how to set formula for let/filter to expand the details, thanks.

[@rrki]

yes please, this extra thing you talk about in 5 min 10 sec, please more details. thx

[@stephengipson6668]

Yes I will like to learn more!!!

[@feelosophy1921]

Made me miss using Excel every day😢

[@dinethprabash1001]

like to see that formula to popup sub-table

[@FrancisDeligero-s2o]

How do you select one checkbox at a time?

[@kevincurtis4598]

Sadly, I'm limited to my IT department admins and don't have this the easy way

[@DingusBatus]

04:35 Show Details on a Table. I can follow the formula until it gets to the "IF" function? you have something going on over in $O$3:$P$3 but give no details about it? It looks like you have something going on in that range then using that as part of the VSTACK/EXPAND in $J$3:$K$3? A further explanation of the full formal would be greatly appreciated. Edit: I downloaded the workbook so I could follow along. Very clever. 😀😍

[@ExcelCampus]

Thanks Debbie! $O$3:$P$3 contains header for the show details table. $J$3:$K$3 are blank cells used to add padding and move the show details table down to align it with the row where the checkbox is checked. I'll be doing a follow-up video that walks through the entire formula in detail. I believe some of the techniques used in this formula can be useful for other scenarios as well.

[@benosborne413]

Show Details on a Table - video please

[@rumeeburu3648]

What excel version is this available in?

[@rajeevgosavi4514]

OFFICE 365

[@ExcelCampus]

I talk about availability and compatibility with Excel versions at 11:14 in the video. We just added a chapter marker to make that section easier to find. I hope that helps. 🙂