Format cell as a checkbox (TRUE, FALSE)
Offer a format that displays the boolean value of a cell as a checked box if TRUE, unchecked box if FALSE, grayed box if text or other nonbool.
Bonus: Toggle value OnClick would be intuitive.
Lots of uses for this. Current options are awkward for users. Yes/No dropdown is not as good as a checkbox for touch/mobile.
Thanks for the idea! We think formatting cells as a checkbox is an interesting suggestion, but we won’t be able to address it in the near future. We’ll continue tracking votes for it.
I can't believe this is not an option, it's ideal for students. A single click toggle selection is intuitive, I should be able to display a number of different styles (crosses, checkmarks, etc), and store a variety of values (0, 1, True/False, % etc).
Stuart Bisset commented
Checkbox would be good, but formatting as an on/off slider (click once to toggle) with similar aesthetics to android/iOS phone settings controls would be great. Professional modellers are trying to design complex models that also have a good UI/UX and having this in-cell functionality would be awesome.
Hope this isn't regarded as off-topic, its essentially the same request for a binary switch but with an alternative look.
Esther Pettigrew commented
I've just started using Google Sheets and this is one of the key things that I love more in Google Sheets than in Excel. Simple, user-friendly. And being able to toggle the value On-Click isn't bonus, it's absolutely required for usefulness.
Jim Bickford commented
Google sheets makes this easy to do.
Jill Lord commented
Smartsheet has this, its great, shame its not in excel.
Your plans may not change but that of your users will. Ignore your customers at your own risk. Or become the software you help put out business - Lotus 123 - remembered only by the few.
Arne Munther commented
Sound like very good idea.
You guys are really dropping the ball here!!! WAKE UP!!! This is a feature that REALLY needs an overhaul and both google and even apple for that matter are far ahead of you and you are just going to say you are not interested. You guys are making a BAD decision and you will regret it in the coming years as all your customers slip away and you have no clue and the real reason is something as small as checkmarks. Google is making it SUPER easy and a lot of people are switching over because of SIMPLICITY. You can keep the old way of doing things if that would make you happy, but for the love of a good spreadsheet software add a simple checkbox! Putting it in Data validation would be fine, or having it as a format, doesn't matter, just make it before this hole in the ship sinks you!
My Excel files are quickly losing ground to Google Sheets at work because executives want simple functionality that's only available in Sheets - the checkbox is just one example.
i have a 137 x 137 bool matrix to configure manually.. this would be nice
The functionality should be very easy to be implemented... or?
I would really like to see this. I have partial files in Google Sheets just for this feature as well as a simple date picker just using data validation. We are pushing hard to use MS Teams with Excel online built into some of the tabs and this missing feature is really lacking. It's always one step forward them two back to meet our needs. We finally got Sheet Views this month but now I need check boxes and a date picker easily implemented in Excel Online.
Craig Beuthin commented
Brilliant - I already have thought of many situations where that would work for me.
Jon Wittwer commented
I'm finding that this feature alone is why I now use Google Sheets for ALL of my to do lists, instead of Excel. Yes, even though I can press ALT+Down to open a drop-down and select a check mark (my make-shift method for checkboxes in Excel), there is just something awesome and fun about clicking on a checkbox that makes the Google Sheets implementation better than work arounds with Excel.
Microsoft, don't forget to pay attention to the little things! You don't have a monopoly on spreadsheets any more, so let competition drive you to become even better.
@NB: Your excel-hack link couldn't be a better illustration of the need for this. Perfect. Thanks!
Convert True False To Checkbox Controls With VBA
This section will introduce a VBA macro to convert multiple true and false to checkbox controls in Excel. Please do as follows:
1. Select the cells equal to “TRUE” and “FALSE” you will convert to checkboxes.
2. Press Alt + F11 keys together to open the Microsoft Visual Basic for Applications window.
3. Click Insert > Module, and then paste below VBA code into the new Module window.
VBA: Convert TRUE and FALSE to checkbox controls in Excel
Dim xCB As CheckBox
Dim xRg, xCell As Range
Application.ScreenUpdating = False
On Error Resume Next
Set xRg = Selection
For Each xCB In ActiveSheet.CheckBoxes
For Each xCell In xRg
If (UCase(xCell.Value) = "TRUE") Or (UCase(xCell.Value) = "FALSE") Then
Set xCB = ActiveSheet.CheckBoxes.Add(xCell.Left, xCell.Top, cDblCheckboxWidth, xCell.Height)
xCB.Value = xCell.Value
xCB.LinkedCell = xCell.Address
xCB.Text = ""
Application.ScreenUpdating = True
4. Press F5 key or click the Run button to run this VBA.
Then you will see all selected TRUE and FALSE are converted to checkbox controls. TRUE is converted to a ticked checkbox, and FALSE is converted to an unticked checkbox.
Not as easy as Google sheets but this page shows how you can do it all within Excel
Jason Szotak commented
Google Sheets does this with data validation which works perfectly. Time to catch up MS.
Allan R Veler commented
This is one of the features I use the most in Google Sheets, it would be great if it was in Excel as well.
How is this not an option yet? This should've been implemented in the 90s. Cmon!