Share this article
Latest news
With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low
Copilot in Outlook will generate personalized themes for you to customize the app
Microsoft will raise the price of its 365 Suite to include AI capabilities
Death Stranding Director’s Cut is now Xbox X|S at a huge discount
Outlook will let users create custom account icons so they can tell their accounts apart easier
Here’s how you can insert a checkbox in Excel
The feature is available on the Beta Channel, for now.
2 min. read
Published onOctober 9, 2023
published onOctober 9, 2023
Share this article
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
You have asked and the Microsoft gods answered: you can finally insert checkboxes in Excel, now, according to the Redmond-based tech giant’slatest blog in the Microsoft 365 Insider.
Microsoft says users will be able to visualize and set TRUE and FALSE values in a cell using checkboxes. The feature was long requested by Excel users everywhere, and it’s something other sheet data apps, such as Google Sheets, already have.
And if October is already a big month for Microsoft 365, withthe new Teams coming, along with a lot ofnew changes to OneDrive, then the other apps, such as Excel, needed some love too.
So, Microsoft added a new ribbon group called Cell Controls. This new pane will introduce checkboxes to Excel. However, this is the first feature of many, as Microsoft promises there will be more.
How to insert a checkbox in Excel
In the image above, you can see the checkboxes in the selected cells. The blank cells are automatically set to FALSE.
Microsoft says that checkbox formatting only works with Boolean values and blank cells. Any other values, such as number and text, are ignored. And, if the active cell has a checkbox, you can toggle the values of all selected checkboxes by pressing the space bar.
However, for now, users won’t be able to directly remove checkbox formatting in a cell. Instead, you’ll need to selectHome > Clear > Clear Formats.
For now, this feature is available to Beta Channel users running Version 2310 (Build 196924.2000) or later, but it will come to the Excel Stable Channel in the following weeks.
Are you excited about inserting checkboxes in Excel? Let us know your thoughts in the comments section below.
More about the topics:Microsoft 365,Microsoft Excel
Flavius Floare
Tech Journalist
Flavius is a writer and a media content producer with a particular interest in technology, gaming, media, film and storytelling.
He’s always curious and ready to take on everything new in the tech world, covering Microsoft’s products on a daily basis. The passion for gaming and hardware feeds his journalistic approach, making him a great researcher and news writer that’s always ready to bring you the bleeding edge!
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Flavius Floare
Tech Journalist
Flavius is a writer and a media content producer with a particular interest in technology, gaming, media, film and storytelling.
