03.10.2023, 23:46
Moin
Erst mal nur im Insider-Kanal.
https://www.youtube.com/watch?v=kunbe45v7-E
In this YouTube video, Bill Jelen enthusiastically announces the arrival of checkboxes in Microsoft Excel. They reminisce about the challenges they faced with checkboxes in the past, particularly when working on a report card system for a school district.
Jelen demonstrates how to use the new checkbox feature, emphasizing its location on the "Insert" tab. They show how to insert checkboxes into cells, toggle them on and off, and even use the space bar for quick toggling. The video also explores the underlying true or false values associated with checkboxes and how to remove them to revert to regular true and false values.
Some limitations are discussed, such as the inability to use checkboxes in data validation or within pivot tables. The video also highlights a peculiar behavior where hovering near existing checkboxes seems to automatically insert and activate new ones, though the exact rules for this behavior remain unclear.
The speaker attempts to address the question of displaying words next to checkboxes and mentions that some methods like number formatting didn't seem to work, inviting viewers to share their insights in the comments.
The video concludes by noting that if someone without the feature opens a workbook containing checkboxes, they will see the values as true and false. The speaker expresses gratitude to the Excel team for the feature and thanks viewers for watching, leaving them with the promise of more content in the future.
Um es mit Edi Finger zu sagen: I werd narrisch.
Erst mal nur im Insider-Kanal.
https://www.youtube.com/watch?v=kunbe45v7-E
In this YouTube video, Bill Jelen enthusiastically announces the arrival of checkboxes in Microsoft Excel. They reminisce about the challenges they faced with checkboxes in the past, particularly when working on a report card system for a school district.
Jelen demonstrates how to use the new checkbox feature, emphasizing its location on the "Insert" tab. They show how to insert checkboxes into cells, toggle them on and off, and even use the space bar for quick toggling. The video also explores the underlying true or false values associated with checkboxes and how to remove them to revert to regular true and false values.
Some limitations are discussed, such as the inability to use checkboxes in data validation or within pivot tables. The video also highlights a peculiar behavior where hovering near existing checkboxes seems to automatically insert and activate new ones, though the exact rules for this behavior remain unclear.
The speaker attempts to address the question of displaying words next to checkboxes and mentions that some methods like number formatting didn't seem to work, inviting viewers to share their insights in the comments.
The video concludes by noting that if someone without the feature opens a workbook containing checkboxes, they will see the values as true and false. The speaker expresses gratitude to the Excel team for the feature and thanks viewers for watching, leaving them with the promise of more content in the future.
Um es mit Edi Finger zu sagen: I werd narrisch.