NEW Excel Checkboxes are AMAZING | Checkboxes are now in cells!

preview_player
Показать описание
In this video, we explain the new excel checkboxes that have been recently released by Microsoft in Excel 365. They are currently only available for the Excel 365 insider beta channel, but they should be rolled out to all Excel 365 users soon.

Join the Microsoft Insider program:

Download Example files:

00:00 Introduction
00:59 Inserting the NEW Checkbox in Excel
01:21 Deleting the checkbox + Ghost mode
02:23 How the checkbox works + Example 1
04:34 Changing the colour of the checkbox + conditional formatting
05:27 Using the Spacebar to check and uncheck + Active cell
06:34 Example 2 + Filtering for unchecked items
08:08 New vs Old Checkboxes
09:39 Conclusion

Follow us on Social Media:

*****My online Excel Courses*****

#checkboxes #checkbox #excel
Рекомендации по теме
Комментарии
Автор

damn thank you for explaining, i’ve been harassing the update since “that” checkbox is MIA in my excel, finally figured out it’s available for “insiders” and will eventually roll-out…fudge why does other youtuber didn’t bother to explain it 🤦‍♀️🤦‍♀️🤦‍♀️ thank you again 🙇🏼

sajoh_
Автор

Major flaw with checkboxes (unless there is a work around). The checkbox is an object and if you use multiple boxes in a list and then if you filter a column in the table the checkboxes and their format gets all screwed up

tonyguerrier