BRILLIANT, as always! Can't wait to get check boxes. I also learned, from this video, when IF/THEN references values that are already boolean, I don't need to say ...C4="TRUE"...C4="FALSE" Makes total sense, but I never thought it through. Oh, and I learned you can, apparently, use emojis in your worksheet names! Very nice!!
Retaining 'true' and 'false' could arguably make the formula more human readable, might be worth considering if others will need to understand and maintain your code. But yeah, cool to know that we don't have to use them :)
Great video!! Check boxes can handle 3 state systems not only binary: ghost(deleted),unchecked, checked. First example can be handled by a single clm of checkboxes, ghost state means we have to buy, unchecked means we have it unpacked, checked means packed =SWITCH(chck box range,0,"Buy new",FALSE,"Need to pack",TRUE,"Packed") Other 3 state examples: not arrived, arrived, left not interviewed yet, pro, contra maybe, yes, no.....
Thanks! Great idea, the only issue would be if you accidently check and box and then uncheck it, it now contains FALSE but what you really want is an empty cell.
@@MyOnlineTrainingHub Thanks!! Tri state: deleted, checked, unchecked or bi state: checked, unchecked, are equally exposed to "accidents". Having 2 clms you can "accidentally" pack something you do not have yet.😊
I want to correct you at 4:02. You have to change the maximum value to manually 100% under "format all cell based on their values" option. This way, the bar will fill up according to the percentage value in the cell. If you don't do this, the bar will be based on the highest value in the column, which might not be 100%. For example, if you only choose the first option, the highest value will be 25%, and the bar will look full even if the cell value is lower.
Thank You for an AweSome Video. GOOD NEWS: As on 25-Jul-2024, the Checkboxes auto-appear when new rows are added in a Table 🥳 My Version Details: Current Channel . . Version 2406. Best Wishes!
very very good explanation. I couldn't know checkbox format trick. Thank you Also, I have discovered worksheet name symbols:) We can add some ordinary symbols in name section of worksheets. 🎇🎇
Great feature and as always a great video thanks Mynda! So pleased it has finally arrived on my quite locked down 365 version. On mine, the control is between the Illustrations and Charts area of "Insert"-not sure why.
Glad you like them! This video was recorded when they first came out in beta. Through the testing phase they decided to relocate their position on the ribbon.
I have been waiting months for this feature and I am in the Beta preview since November. By chance I checked the "Customize the Ribbon" and it is in there under "All Commands". I then created my own Group called "Cell Control" and added the check box. Note: there are three check box options, make sure you do not select the ActiveX or Form Control but the one without a space "Checkbox"
@@TelesisREI Thank you so much for your prompt response to my doubts. Appreciate. I do not have the third option which is "one without a space "Checkbox" Where should I see "Beta preview" it seems I am under Beta preview?
I am running beta version 2406 built 17911.20000 and I have them. If you're on the beta channel and your version is lower than this, then try updating via the File tab > Account menu. Otherwise, if you're on the current channel for Office 365 on Windows and Mac Desktop, then try updating.
@@MyOnlineTrainingHub Based on your tip I moved to Beta from Current Channel and am on 2408, build 17911.20000. No check box, and no PIVOTBY/GROUPBY either.
The link is in the video description. Here it is again for your convenience: DOWNLOAD the free example file here: www.myonlinetraininghub.com/excel-checkboxes-in-cells
Really nice video, Mynda. I have not found out, but I wish there was a possibility to avoid selecting more then one check-box in a row. is this possible or do yuou know a work-around.
Thank you! You can check the boxes one by one with your mouse or select the single cell and press the space bar to check/uncheck it. Not sure if that answers your question, or maybe I've misunderstood.
Mynda, your tutorials are fantastic. Can you explain how I would add checkboxes to a filtered list? So I can check off who's attended and who hasn't attended from a filtered work department list. When I tried this the checkbox remained static if an employee was removed from the original data. Thank you.
Yes, they did change the location. This video was recorded when they first came out in beta. Through the testing phase they decided to relocate their position on the ribbon.
Unfortunately it's impossible to insert these checkboxes with VBA. So I have no opportunity to apply a range of checkboxes to dymamic array. Looking forward when this problem will be solved
Very useful tutorial, thank you very much! I especially liked the flagging solution of the Filter topic. I would like to ask, do you think the efficiency of combined IF or Switch functions is better than IFS? Which one would you recommend in terms of performance? Thanks! (Offtopic: it was nice to see you using the new Navigation Pane, for my part I would really like to see it further developed and a much more useful version released. I guess, you've also already seen that in the case of a large report, you can only use an optimized naming convention use your filter well, because unfortunately all ranges/objects are listed. I really, really miss an object filter and a pin/unpin solution to make it more customizable and efficient. Maybe you have information about whether MS plan to develop it or not? Unfortunately, I did not receive any feedback from them regarding this, thank you!)
Thanks for watching! I haven't done any speed tests on SWITCH vs IFS. Another option is to use XLOOKUP on a sorted list, which will be the most efficient.
😁these stickers were given to my by Microsoft. I'm not aware of them being for sale anywhere, sorry. However, copies of the t-shirt are available on Redbubble.
Ah! This could be at least a partial answer to limitations we have with formatting slicers. Looking forward to trying it, thanks for the heads up. As an aside... 5:29: am I going mad or has something recently changed with the way Aptos Narrow is rendered? Numbers look terrible at size 11, totally inconsistent with letters/symbols. Increase to 12 or decrease to 10 and they look fine. Can't remember that being the case when the font was first pushed out.
Great to hear! Regarding Aptos Narrow, I suspect it's just the zoom level of the video at that point in the recording 🤔 I tested it in a file and it looks ok to me when compared to 10 and 12 point.
Lazy question but can you have 3 options or only 2? That's often a blind spot for check boxes. Should include a 3rd code/icon for an unknown or nil return or non-conformance or pending etc. Also occurs to me that radio buttons used to provide the multiple unique option feature, is that available now as a cell type?
@@MyOnlineTrainingHubVery useful indepth teaching on the new checkboxes. I hope next development here will be an option to group the boxes and make them mutually exclusive.
I am unable to see the option to insert checkbox? How do I add it. If you rty to add it to the ribbon, I get the option to insert the old-type checkboxes.
Thanks for watching! The new checkboxes are still in beta, so unless you're on the beta channel you won't have them, but hopefully they'll be generally available soon.
@@MyOnlineTrainingHub Did I miss the mention of beta in the introduction? I'm searching and googling trying to find checkboxes and all I could find was a development tool that didn't act the same way as this tutorial. Is running beta expected for normal use?
Hello, Mynda, I have followed Microsoft forum suggestions to add DEVELOPER to then find the checkbox (active x and form control), edited ribbon and added to new group in INSERT. But when I try highlighting and placing the checkbox in excel, the checkbox behaves as if I am trying to install a text box.
Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20346) 32-bit is this correct? Edited ribbon and removed the checkbox Active x control / Form control that I initially added in and apparently are objects. I read below 6-months ago checkboxes only on some beta versions. Should they be available on my version (above). Understand you are not tech support...if you know anything of help to me please respond, otherwise I will strive to determine how to proceed as this function could be very useful to my team. Thanks
According to Microsoft: Right now, if a user is on Current Channel and does not have updates pending, they currently have a 50% chance of having Checkboxes on a given device/install. Fortunately, in all likelihood, it should be fully available for Windows Desktop users by the end of July, and across all platforms shortly thereafter.
If you can see the checkbox icon but it's greyed out, then I'd try starting a new file and see if it's still the case there. If it's still greyed out, then I'd reboot and see if that fixes it. Otherwise, maybe you have an object or something else selected that isn't compatible with applying a checkbox.
I am using a 365 excel but when i highlight an entire column then click the check box button it doesn't make it all checkbox like in the video. I have to individually draw every check box and that i feel is painstaking, what could be the issue also I had to update my excel again. I hope to get a response from you thanks
@@MyOnlineTrainingHub I'm using MS Office 365 on Windows with an E3 license, installed version 2406 (Build 17726.20160) which is the latest version as per MS on Current Channel. Still no checkbox. Is this part of any add-in?
According to Microsoft: Right now, if a user is on Current Channel and does not have updates pending, they currently have a 50% chance of having Checkboxes on a given device/install. Fortunately, in all likelihood, it should be fully available for Windows Desktop users by the end of July, and across all platforms shortly thereafter.
i already have Microsoft 365. i just updated it today. check box still not appeared in insert menu. so i need to know the reason and how can i add checkbox in insert menue? thanks for your help
I'm a member of the insider beta group but do not see the check box option on the install ribbon. Is this something that I have to install from somewhere?
As far as I know they're available to all beta users, so maybe you just need to check for updates. There's nothing to install as such. If they don't appear after updating, then they must only be flighted to some beta users, in which case it's a lottery and you didn't win.
Would love some help from anyone. I have a total contract cost for a standing purchase order. I have a list of estimates and a checkboxes for the status. If the checkbox is selected, I want that estimate amount to subtract from the total contract cost.
@thomasferreira7818 checkboxes are now available for users on the Current Channel for Office 365 on Windows and Mac Desktop so if you have one of these licenses, then you can run the update from the File tab > Account to get them.