Grab the file I used in the video from here 👉 pages.xelplus.com/checkboxes-new-file I hope you like the video. Checkboxes are currently a Beta feature in Microsoft 365. Hopefully it will be rolled out soon to everyone.
Were can we follow up on new releases to make sure the updates roll up?, I finally was abe to use the insert image on cell, really nice feature, but it took a while to be released with some minimal changes to the way you showed on your video
Love that it wasn't JUST about checkboxes, but included interesting elements of design and a few cool things you can do with checkboxes. I think this is one of your best videos.
Any idea why this is taking so long to be release? I have 365 for business and we still don’t have this yet I’ve seen questions on it online dated back in September of last year!
WOW, this iterative calculation mode opens up a completely new world of possibilities (and trapdoors 😂)! Thanks heaps for drawing our attention to this!
This looks like a great feature, and I was looking forward to following along with your turorial; Alas, my work and personal versions of Excel 365 do not have this option on the Insert tab. Is this just a feature I have to wait to be rolled out?
This would be a game changer for those who are still using Excel as dashboards. We are already using Power BI but I'll try to play with it once it's out. Thank you, Leila! ❤
This checkbox functionality is so good! It’s been a constant frustration for me that learning and using checkboxes in Google Sheets takes about a minute to learn, but on Excel, it had the confusing and clunky developer tab. Now we’ve got simple checkboxes! Hooray!
Thanks Leila. This is an absolute beauty! Well, while practicing this, I used the following for the IFS function from the other side, =IFS(C4=TRUE,NOW(),C4=FALSE,""). This is because I didn't want to turn the iterative calculations. I have used it once on some jobs and it slows the sheet operation down. All the same, thanks a lot for this
It would be nice if they had an "iterate" function so instead of an option that affects the whole workbook, you could control it at the cell level. It might be nice to revisit this to show how you could automatically add and remove items from your list.
As I said you can do it with Lambda. Create a named lambda function that accepts at least two inputs, your value to be iterated on and an integer that you count down. Do your thing with the value and decrease the counter by 1. Exit when you reach 0 or hit another exit criteria. Modify the values inside the function and let it call itself. Done it with a formula to calculate pipe friction factor (funnily this is the gel letter Lambda in physics) which for the turbulent Colebrook function is iterative.
Oh my goodness. I have been waiting for this! The lack of a real functional checkbox like this was leading me to use Google Sheets more than I would like, and now I can primarily use Excel!
Checkboxes were available years ago with EDITGRID (which Apple seems to have made totally invisible since they bought it around 2007 to make into “numbers”). They have been available in Google sheets quite a while too.
A simpler method to count checked items. Instead of: =COUNTIF(C5:C13,true) you can write: =SUM(--C5:C13) The double-minus converts TRUE's to 1's. Hope this helps :-)
@@mustafamalik4211 not in this case 😞 =SUM(N(C5:C13)) will return a wrong solution! Alternative methods that do work: 1) =SUM(1*(E2:E13)) 2) =SUM((E2:E13)+0)
If by simpler you mean “sum” is shorter than “countif”, well…okay, but trivial. Otherwise, I would argue that it’s not simpler because the logic is not as obvious. If someone else was reading or debugging this formula they likely would have no idea what was going on. Also, I suspect the run time of your “sum” is longer than the “countif” - but I haven’t tested it. I’d be interested in seeing the results of that. But yeah, this is a nice trick to know.
It is a fancy technique, but allowing iterations throws a lot of undue overload to the CPU and if accidentally used for large worksheets it may cause delay, slow-down, and non-responsive sheet sort of problems. But, to impress someone for a little while, it is a good change of mood technique. With all the above criticism, the overall presentation of the video is good and some new information about the check-box is also useful. That's why I always recommend this channel for beginners and professionals who have problems with Excel so that they can easily understand and apply the technique in their work.
I have a sheet where the checkboxes are in different columns, not all lined up in one column. When I apply the conditional formatting I can't get the same rule to apply to the other columns... basically I want it to "look to the cell on the left (checkbox)l and if true then cross out the text in this cell" ... currently i have to make a few different conditional formatting rules for each separate set of checkboxes with associated cells next to them which are not all arranged in a contiguous column.
Ouch, I always used to go for visual basic to get my timestamp, now this is surely a lot lighter... I will try it soon for sure Big thanks master, keep blowing our minds 🤯
Two initial thoughts: 1) Check boxes will be very handy for Checklists (obviously) but I personally would prefer to see 'Completed Tasks' as a percentage, i.e. 47% completed (which would be easy to do), 2) several years ago I used check boxes in charts which allowed the viewer to build layers of information one piece at a time rather than blasting 6, 7, or 8 pieces of information at the same time. At the 11:35 mark " ... but stay with me ...". 'Always' ... wouldn't dream of going anywhere else. Thank you ... thank you ... thank you ... 😍😍😍
This is amazing! I work with a PM that uses colors to represent everything. When I need to work on her info as data, I have to go and copy out cells based on colors to export them. I got her to use the sheets, but this will give us just what we need (with a few tweaks). Thank you!
Would be cool if checkboxes were formatting that could be added to the sheet dynamically. For example if you enter an item on your list in column A checkbox would appear in column B. Great video thanks.
When you say " It doesn't work," do you mean that if you convert the learning list to a table, the checkboxes will not be added dynamically as you add new lines to the table?? That seems odd.
Hey Leila! Can you make a video on how to reconcile 2 sets of data together? Like to quickly identify numbers that are in one table but not in the other. I feel this comes up a lot in finance. Thanks!
Add one column to each data set. On the first data set new column insert "SET ONE" in all cells,, On the other data set new column insert "SET TWO" in all cells. Append one set over the other. Analyze the resulting data set with a pivot table . Ciao from Venice, Italy
@@renatovianello874 Interesting! I never thought to approach it that way. I usually index one set and xlookup the other set. I must try your approach next time. Seems simpler.
Apple Numbers has had checkboxes for many years. I use them daily for almost all sheets to be able to switch formulas on and off. Pretty useful. Happy for Excel users.
This can be especially powerful when building dynamic dashboards. Imagine having 6 business units that make up a company. You can aggregate different combinations of the business units with a checkmark using the SUMIF function.
That’s what I’m gonna be doing ,but with the org chart as my driver because I’ve got different people responsible for different cost centers that don’t roll up the same way in our GL
WOW! I just finished slaving away for a client at creating a massive Risk Management risks selector using checkboxes (the old way) and assigning each one to a cell to I can record the true or false value and then do whatever I want with it from there. Now I see this and I smile and cry at same time.
There's nothing I hate more than to see a useful feature demonstrated then when I go to use it, it's not there. She should explain it's only available in the Beta version and how to get it!
It is just VERY frustrating when Microsoft takes forever to roll out these new options. This has been around for months now and still not showing in my Excel. And above all i am using the Enterprise license, one would expect they would look better after there high end users. I know you can activate the Beta features, but tried it a few years ago and suddenly things did not work anymore. so not willing to take the chance.
Can still use this in developer tab, but when you say use this with care, what do you mean? Does quantity of check boxes cause any room for careful pause?
Leila, I really appreciate your videos, but I find it frustrating when you publish feature that is unavailable to everyone. Not even with a business standard license. At least a warning and an expected date could be useful.
I am learning from Myanmar. I cannot make it, because of my Excel version (Crack Version). I want to prepare my attendance statistics using a check box. I really do it. But I couldn't. Do you know how you can help me? Whatever thank u for your sharing. Thank u so much.
Nice one Leila. I signed onto Beta and, after a few attempts, was able to insert checkboxes as intended. I'm running 365 (2024) and the formula at the end (=IFS(C5=FALSE,"",D5="",NOW(),TRUE,D5) returned Circular Reference error, resulting in 0 (twice). Instead of giving into the temptation of giving in, I continued with the video and altered the Formula settiongs as you described. Now it works as intended. Many thanks. Edit. I pasted a link to this video in my Worksheet for future reference. Just in case I forget how I achieved it.
AWESOME! Simply awesome! What a video! What an exceptional explanation! What an exceptional expert! Loved everything, Leila! And you, who is reading this and have not even subscribed to this channel yet: you have the moral duty to subscribe right now! This is just a piece of magic that Leila can do with so many resources. Thank you for sharing, Leila! This video might well be highly rated to be one of the bests you made so far!
I think this function is still not avaliable just as showed in the video right? The only one I got is the same of a video made 2 years ago, without dynamic reference.
Great video and I was able to apply it to Google Sheets with no problem, except the text in the shape. Thanks so much for all you do. I have learned a lot from your videos as well as the courses I purchased. Keep up the great job you do to help others.
This was one of your best videos. So well thought out. Learnt a lot. There is lot that you can learn when given a simple example. The most important thing is the practical uses of this in the workplace.
This helped me get hired at a new company today. I’ll be making three times more money and paying for my daughters college as a result. Thank you, Leila!
The checkboxes are really good, but my mind was blown with a couple of other examples you provided: the iteration setting, and placing a shape on top of cells and using transparency. Thank you so much for always providing such great examples to teach us!
I haven't viewed one of your videos for some months now; but I am pleased to see the level of professionalism is still very high. I especially liked the little cameo ovals of you speaking. VERY nice!
First, thanks for the video. It is very entertaining to watch. You never get bored and unlike most excell teaching videos, you have given a real effort for editting. I'm using the latest version of Excell and my "Insert" tab does not have a Checkbox option. I've looked through customizing the bar options and the button I found for a checkbox was the same old Form / ActiveX checkbox option. So, what did I actualy do wrong?
Glad you liked the video. You did nothing wrong. But these new checkboxes currently are still in beta. You'd have to join 365 Office Insider to get it now.
Does iterative calculation support UNDO? For example if you select COMPLETE checkbox and then DESELECT accidentally… and RESELECT COMPLETE, will the ORIGINAL timestamp REAPPEAR or will it only take on the NEW timestamp?
Many times I have wished to be able to use the today() function to autofill and then remain as a timestamp. Well today() is that day! Thanks for pointing out the iteration setting. Just checked, and this works in Google Sheets as well. Very helpful video. Thanks!
I have been struggling with Timestamps not working properly. Thanks for the heads-up on the “Enable iterative calculation” and the well written date formula. I’m using it not with Checkboxes but with drop-down lists.
Thanks for the video and I have now just updated Microsoft 365 and finally have them, so I can start playing with confidence because of your 'excel'ent tutorial. I want to see if I can use them to filter a list, among other things!
First and foremost let me say that the video is really good and for more than just the new check boxes. I always enjoy your videos and your courses, so thank you very much for taking the time to making this video!! An issue that seems to be a consistent one from the responses: When (if) I finally get it, it will be lost in history. It might be useful to "remind" us of this video when it more generally available. FYI - I am on the "insider" channel.
Thank you for the videos. I have been out of collage a long time (2004). I finally got my engineering tech position, and I have had to try to remember all the Excel stuff. Your videos have helped me a lot. I did this video as you showed it. It worked as yours did. Then I applied it to my annual task sheet which has 100 or so task lines, but only a few have projects listed in the projects/Tasks. The rest of the lines are blank. where the blank ones are there is a 0 on my not completed task list. I am guessing this is due to nothing being on the line, so it is a place holder. Is there a way to not have the 0 show if the line is blank? Thank you again.
So I love the ease of this. I created a spreadsheet to check on Quality Audits and get a score. Once done, I would love to clear it so I can start over on the next one. Is there a way to create a clear checkboxes when using the insert checkbox feature? Thank you for sharing your knowledge with us!
This could be super-useful. I can finally introduce something to our organization that I've been hoping to implement for years! I have two question: (1) If the checkbox is unchecked and re-checked, does the timestamp refresh? (2) Is it possible for the timestamp (or an adjacent cell) to indicate the name or initials of the person who checked the box?
Is there any special version of 365 that this works in? I have Microsoft® Excel® för Microsoft 365 MSO (Version 2403 Build 16.0.17425.20124) 64-bitars, and here is not the Checkbox option.😔
Ms. Leila! I am one of the "brilliant" students in your courses. This video comes just in time. However, I had to become an insider to follow the lesson. Otherwise, I would have waited for the live version.
Why is the checkbox feature not available on my Windows 11 computer? The checkbox feature I am talking about is here at the 1:39 mark. In order for me to add a checkbox in my Windows 11 I have to use the Developer option to add a checkbox however on Excel on my MacBook the Insert>checkbox is available
Finally Microsoft!! Great video. Thanks for sharing. Is it possible to populate the profile of the account user who checked the box? Similar to what you see in Word when someone adds a comment. If this is possible, it would be a great way to track who completed what.
3 months later, many tutorials done, the thing has been tested all over the planet and is still not available to all O365 subscribers... worse buzz ever. Close to the deceptive advertising.
"Mam your video has proven to be extremely helpful for our data career. We kindly request you to provide a link to the dataset so that we can practice immediately.
checkboxes? ... cute! .... but the real gem here is the automatic, permanent Timestamping!!! I have been trying to solve this for everrr (like 20 years) ... thanx so much Leila, this solves a problem for my team that has been a headache for a long long time!💕
Finally a REAL checkboxes as there are in google sheets. Shame that is only available in 365 for now, I have so many ideas to implement those in my workplace which has Office 2021
Dear Leila, Thanks for the great video! I am looking forward to using the new cool Checkbox feature. I imagine I can apply this tool for my current course check task. Quick question: I have a list of course to check whether they meet the numbers of requirements (ie, 10 elements). - From the video, I can easy check the status of each course. - However, I also want to record the status of each course before I check another one and be able to go back to previous course for status modification (ie, from not completed to completed). => Is it possible to set up this in Excel with Checkbox feature? Thanks for your advice on this.
@LeilaGharani, Thank you for this video. I was able to apply the timestamp trick you showed in the video and it worked!!!!! At first, I did it differently and each time I clicked the checkbox the whole time updated. But when I applied your method and applied iterative calculation check on it, it worked. Thank you, again.
Also, I was able to combine this checkbox on task done to my dynamic excel calendar. I have a separate sheet with tasks and dates (DDD, DD-MM-YYYY). I have another sheet in the same workbook where I did a monthly calendar with a conditional Formatting highlighting Today's date which changes dynamically each day. Beside the calendar I have a task list comprising of 10 tasks, a checkbox for completion, and a timestamp. I used the filter function to select tasks for the day from the task sheet to the calendar sheet and I tick them off when done. Thank you once again for your lectures.
Thank you for the stunning video on checkboxes and their usefulness. My check box is not on the far right end of the ribbon. It's in a group by itself in the middle and the name of the group is "Control". But it seems to work the same. Why is that? Thank you so much in advance.
Glad you like them! Unfortunately, there is no fixed ETA from Microsoft. As far as I know they're still tweaking the functionality based on user's feedback.
This is a great tutorial. I plan on using it to keep track of a number of tasks that I have to complete to prepare for an upcoming surgery. I can see many uses for this type of tracking table. You explain things so well and it is easy to follow along..I had to update my version of MS 365 using the latest beta versions.
i think i will be using the checkbox timestamp. i have an excel spreadsheet that tracks user inputted date and time. this would make quick insertion work for the beginner user.
![[#2024MAMA] ROSÉ (로제), Bruno Mars - APT. | Mnet 241122 방송](http://i.ytimg.com/vi/dgGqD28J6aQ/mqdefault.jpg)
Grab the file I used in the video from here 👉 pages.xelplus.com/checkboxes-new-file
I hope you like the video. Checkboxes are currently a Beta feature in Microsoft 365. Hopefully it will be rolled out soon to everyone.
Can you show us the consequences of using iterative calculations incorrectly
I really like your helpful tutorials ❤
How do I sign up to be able to use beta features?
Thank You Leila. I was just going to message you that the feature is not on my version of excel. (i do have the current version and get auto updates)
Were can we follow up on new releases to make sure the updates roll up?, I finally was abe to use the insert image on cell, really nice feature, but it took a while to be released with some minimal changes to the way you showed on your video
Love that it wasn't JUST about checkboxes, but included interesting elements of design and a few cool things you can do with checkboxes. I think this is one of your best videos.
Any idea why this is taking so long to be release? I have 365 for business and we still don’t have this yet I’ve seen questions on it online dated back in September of last year!
same for me as of today
@@micheltw Just got it today! I guess it is finally rolling out to more users.
@@micheltw I kept checking, it is still not released.
@@andypereira362 got it on july 31st
You should prefix these videos with the required version of Excel for the features you're discussing.
I wish all teachers were as good as you, Leila .... very clear, consise and useful instruction.
Been waiting 25 years for this
It truly was about time.
Frankly, I find it hard to applaud now, versus decades ago.
"We didn't have the technology 25 years ago for checkboxes"
Microsoft (probably) 😅
It finally works like you would intuitively think it does. 🎉
Totally
Still waiting for the option availability for the non insiders 😩 I don’t understand why MS is so long to distribute this so awaited feature.
It's remarkable how much information she can fit into 15 minutes. Well done!
WOW, this iterative calculation mode opens up a completely new world of possibilities (and trapdoors 😂)! Thanks heaps for drawing our attention to this!
True :) Glad you found it helpful.
Amazing! One step closer to the dream of non-volatile random numbers.
=LET(
cell_address,ADDRESS(ROW(),COLUMN()),
x,INDIRECT(cell_address),
IFS(
x=0,TEXTSPLIT(RAND() & ";" & cell_address,";"),
OFFSET(x,0,1)cell_address,TEXTSPLIT(RAND() & ";" & cell_address,";"),
TRUE,TEXTSPLIT(x & ";" & cell_address,";")
)
)
I have used them to calculate systems of differential equations, it works like a charm!
I have 365 but the checkbox is know where to be found
This looks like a great feature, and I was looking forward to following along with your turorial; Alas, my work and personal versions of Excel 365 do not have this option on the Insert tab. Is this just a feature I have to wait to be rolled out?
I don’t have to
I don’t have to
Same problem
SAME! I'm stuck 😞
This would be a game changer for those who are still using Excel as dashboards. We are already using Power BI but I'll try to play with it once it's out. Thank you, Leila! ❤
This checkbox functionality is so good! It’s been a constant frustration for me that learning and using checkboxes in Google Sheets takes about a minute to learn, but on Excel, it had the confusing and clunky developer tab. Now we’ve got simple checkboxes! Hooray!
It really was about time. Thanks for tuning in, Anthony!
The last trick is something that really amazed me. Thank you again Leila.
I love it too. It was actually one of our team members who came up with it. 🥰
Thanks Leila. This is an absolute beauty!
Well, while practicing this, I used the following for the IFS function from the other side, =IFS(C4=TRUE,NOW(),C4=FALSE,""). This is because I didn't want to turn the iterative calculations. I have used it once on some jobs and it slows the sheet operation down. All the same, thanks a lot for this
It would be nice if they had an "iterate" function so instead of an option that affects the whole workbook, you could control it at the cell level. It might be nice to revisit this to show how you could automatically add and remove items from your list.
With self referencing Lambda you can do something like that
yes, we must have "iterate" control depending on our needs, instead of globalization
As I said you can do it with Lambda.
Create a named lambda function that accepts at least two inputs, your value to be iterated on and an integer that you count down.
Do your thing with the value and decrease the counter by 1. Exit when you reach 0 or hit another exit criteria. Modify the values inside the function and let it call itself.
Done it with a formula to calculate pipe friction factor (funnily this is the gel letter Lambda in physics) which for the turbulent Colebrook function is iterative.
@@FreakAzoiydcould you be so kind to post the formula? Thanks
@@FreakAzoiydPlease how can we get the video or worksheet on how to get this thing done
Aw man, I wish my job had this updated version of excel so I could tinker with impingement this.
Oh my goodness. I have been waiting for this! The lack of a real functional checkbox like this was leading me to use Google Sheets more than I would like, and now I can primarily use Excel!
Oh bummer. Got all excited about the feature only to find it hasn't been added yet.
Checkboxes were available years ago with EDITGRID (which Apple seems to have made totally invisible since they bought it around 2007 to make into “numbers”). They have been available in Google sheets quite a while too.
A simpler method to count checked items.
Instead of:
=COUNTIF(C5:C13,true)
you can write:
=SUM(--C5:C13)
The double-minus converts TRUE's to 1's.
Hope this helps :-)
Alternative to the double minus, it is also possible to use the "N" function" :=SUM(N(C5:C13))
@@mustafamalik4211
not in this case 😞
=SUM(N(C5:C13)) will return a wrong solution!
Alternative methods that do work:
1) =SUM(1*(E2:E13))
2) =SUM((E2:E13)+0)
If by simpler you mean “sum” is shorter than “countif”, well…okay, but trivial. Otherwise, I would argue that it’s not simpler because the logic is not as obvious. If someone else was reading or debugging this formula they likely would have no idea what was going on. Also, I suspect the run time of your “sum” is longer than the “countif” - but I haven’t tested it. I’d be interested in seeing the results of that. But yeah, this is a nice trick to know.
I would definitely use SUMPRODUCT
Not a big fan of "--", any team "1*" out there?
The only excel channel you ever need to follow.
It is a fancy technique, but allowing iterations throws a lot of undue overload to the CPU and if accidentally used for large worksheets it may cause delay, slow-down, and non-responsive sheet sort of problems.
But, to impress someone for a little while, it is a good change of mood technique.
With all the above criticism, the overall presentation of the video is good and some new information about the check-box is also useful. That's why I always recommend this channel for beginners and professionals who have problems with Excel so that they can easily understand and apply the technique in their work.
Please check my reply, where I included a VBA code, which avoids the iterations.
@@nairobi203 I think onchange at worksheet level. Long time ago i used that for some calculations.
I have a sheet where the checkboxes are in different columns, not all lined up in one column. When I apply the conditional formatting I can't get the same rule to apply to the other columns... basically I want it to "look to the cell on the left (checkbox)l and if true then cross out the text in this cell" ... currently i have to make a few different conditional formatting rules for each separate set of checkboxes with associated cells next to them which are not all arranged in a contiguous column.
Ouch, I always used to go for visual basic to get my timestamp, now this is surely a lot lighter... I will try it soon for sure
Big thanks master, keep blowing our minds 🤯
Which Excel are you using? I have Excel 365 and this option isnt on my Insert-tab. Great vid by the way.
Two initial thoughts: 1) Check boxes will be very handy for Checklists (obviously) but I personally would prefer to see 'Completed Tasks' as a percentage, i.e. 47% completed (which would be easy to do), 2) several years ago I used check boxes in charts which allowed the viewer to build layers of information one piece at a time rather than blasting 6, 7, or 8 pieces of information at the same time.
At the 11:35 mark " ... but stay with me ...".
'Always' ... wouldn't dream of going anywhere else.
Thank you ... thank you ... thank you ... 😍😍😍
Great concept in layering the information for easier understanding - really clever! Thank you so much for tuning in!
In Google Sheets I setup percentages often based on the checkboxes. I cannot wait for Excel to get the new checkboxes out to everyone.
This is amazing! I work with a PM that uses colors to represent everything. When I need to work on her info as data, I have to go and copy out cells based on colors to export them. I got her to use the sheets, but this will give us just what we need (with a few tweaks). Thank you!
Would be cool if checkboxes were formatting that could be added to the sheet dynamically. For example if you enter an item on your list in column A checkbox would appear in column B.
Great video thanks.
I think Microsoft might add that because that's a part of the table feature. It just doesn't work yet - but I have a feeling it will be added.
When you say " It doesn't work," do you mean that if you convert the learning list to a table, the checkboxes will not be added dynamically as you add new lines to the table?? That seems odd.
Yeah, seems like a bug which hopefully will be fixed.
Oh my word, finally! They were so behind google sheets it was bizarre! Great that they have finally caught up!
So true!
Hey Leila! Can you make a video on how to reconcile 2 sets of data together? Like to quickly identify numbers that are in one table but not in the other. I feel this comes up a lot in finance. Thanks!
Add one column to each data set. On the first data set new column insert "SET ONE" in all cells,,
On the other data set new column insert "SET TWO" in all cells.
Append one set over the other.
Analyze the resulting data set with a pivot table .
Ciao from Venice, Italy
@@renatovianello874 Interesting! I never thought to approach it that way. I usually index one set and xlookup the other set. I must try your approach next time. Seems simpler.
Apple Numbers has had checkboxes for many years. I use them daily for almost all sheets to be able to switch formulas on and off. Pretty useful. Happy for Excel users.
Yes but you have to suffer through using ios to use it, so it's better to not have checkboxes.
This can be especially powerful when building dynamic dashboards. Imagine having 6 business units that make up a company. You can aggregate different combinations of the business units with a checkmark using the SUMIF function.
That’s what I’m gonna be doing ,but with the org chart as my driver because I’ve got different people responsible for different cost centers that don’t roll up the same way in our GL
WOW! I just finished slaving away for a client at creating a massive Risk Management risks selector using checkboxes (the old way) and assigning each one to a cell to I can record the true or false value and then do whatever I want with it from there. Now I see this and I smile and cry at same time.
For the next client. 😁
Don’t think they can be used in table objects yet, ie auto fill down to new rows. Would be kinda useful to visually see a state of a checkbox
It works in tables but it does not create a new checkbox when a new row is added. Seems like a bug which should be fixed going forward.
Leila, I can't thank you enough. Not just for this, but for all the things I've learned from you over the years. Lady you rock!
There's nothing I hate more than to see a useful feature demonstrated then when I go to use it, it's not there. She should explain it's only available in the Beta version and how to get it!
It's now available
Excellent feature (finally) added to Excel. My goal for YEARS was to have a better Excel Things To Do List!
It is just VERY frustrating when Microsoft takes forever to roll out these new options. This has been around for months now and still not showing in my Excel. And above all i am using the Enterprise license, one would expect they would look better after there high end users. I know you can activate the Beta features, but tried it a few years ago and suddenly things did not work anymore. so not willing to take the chance.
Can still use this in developer tab, but when you say use this with care, what do you mean? Does quantity of check boxes cause any room for careful pause?
Leila, I really appreciate your videos, but I find it frustrating when you publish feature that is unavailable to everyone. Not even with a business standard license. At least a warning and an expected date could be useful.
I am learning from Myanmar. I cannot make it, because of my Excel version (Crack Version). I want to prepare my attendance statistics using a check box. I really do it. But I couldn't. Do you know how you can help me? Whatever thank u for your sharing. Thank u so much.
nice. i do have 365, but no new checkbox feature
I dont see it on my account either and it says that I'm updated. Do you know why this would be?
Nice one Leila. I signed onto Beta and, after a few attempts, was able to insert checkboxes as intended. I'm running 365 (2024) and the formula at the end (=IFS(C5=FALSE,"",D5="",NOW(),TRUE,D5) returned Circular Reference error, resulting in 0 (twice). Instead of giving into the temptation of giving in, I continued with the video and altered the Formula settiongs as you described. Now it works as intended. Many thanks.
Edit. I pasted a link to this video in my Worksheet for future reference. Just in case I forget how I achieved it.
Glad you got it sorted out!
AWESOME! Simply awesome! What a video! What an exceptional explanation! What an exceptional expert! Loved everything, Leila!
And you, who is reading this and have not even subscribed to this channel yet: you have the moral duty to subscribe right now! This is just a piece of magic that Leila can do with so many resources.
Thank you for sharing, Leila! This video might well be highly rated to be one of the bests you made so far!
I'm so glad you enjoyed the video! It's wonderful to hear such positive feedback. Your support means a lot to me!
Amazing, so useful to track when the task is done with timestamps!
WAW!!! I love your explanation. But I have Office 365 and I didn´t locate the Checkbox botton. Could you help me?
I think this function is still not avaliable just as showed in the video right? The only one I got is the same of a video made 2 years ago, without dynamic reference.
I can't wait for the checkboxes to be rolled out. Absolutely fantastic tutorial!!
Great video and I was able to apply it to Google Sheets with no problem, except the text in the shape.
Thanks so much for all you do. I have learned a lot from your videos as well as the courses I purchased. Keep up the great job you do to help others.
you always give something unexpected way to use formula, that's why we love you videos.
That's so nice of you. Thank you so much!
This was one of your best videos. So well thought out. Learnt a lot. There is lot that you can learn when given a simple example. The most important thing is the practical uses of this in the workplace.
Glad you enjoyed it!
Finally. We can insert a checkbox inside a cell. No more struggle in formatting.
This helped me get hired at a new company today. I’ll be making three times more money and paying for my daughters college as a result. Thank you, Leila!
I am really happy to notice that the checkbox became available!
The problem is that when it's added in a table, the function Now() keeps updating...
Very helpful for me in an online sheet. I don't have latest version of MS 365, But your guidance is seriously helpful for online google sheet.
The checkboxes are really good, but my mind was blown with a couple of other examples you provided: the iteration setting, and placing a shape on top of cells and using transparency. Thank you so much for always providing such great examples to teach us!
I haven't viewed one of your videos for some months now; but I am pleased to see the level of professionalism is still very high. I especially liked the little cameo ovals of you speaking.
VERY nice!
Welcome back! Glad you like our new features :)
First, thanks for the video. It is very entertaining to watch. You never get bored and unlike most excell teaching videos, you have given a real effort for editting.
I'm using the latest version of Excell and my "Insert" tab does not have a Checkbox option. I've looked through customizing the bar options and the button I found for a checkbox was the same old Form / ActiveX checkbox option.
So, what did I actualy do wrong?
Glad you liked the video. You did nothing wrong. But these new checkboxes currently are still in beta. You'd have to join 365 Office Insider to get it now.
Whoosh.
Beyond my comprehension.
Thank you for trying to explain.
I really appreciate your skills.❤
Dear Leila, This is the best and coolest checklist I've ever seen. I'm using it for various tasks at work. It's just magic. Thanks a lot for that.
You're very welcome!
What a beautiful voice! I can listen her reading a phone book 😊
Does iterative calculation support UNDO? For example if you select COMPLETE checkbox and then DESELECT accidentally… and RESELECT COMPLETE, will the ORIGINAL timestamp REAPPEAR or will it only take on the NEW timestamp?
Awesome. Do you know when/if this will be available for Excel online?
Many times I have wished to be able to use the today() function to autofill and then remain as a timestamp. Well today() is that day! Thanks for pointing out the iteration setting. Just checked, and this works in Google Sheets as well. Very helpful video. Thanks!
You are a great presenter- I’ll be putting this to all kinds of use!
I have been struggling with Timestamps not working properly. Thanks for the heads-up on the “Enable iterative calculation” and the well written date formula. I’m using it not with Checkboxes but with drop-down lists.
Thanks for the video and I have now just updated Microsoft 365 and finally have them, so I can start playing with confidence because of your 'excel'ent tutorial. I want to see if I can use them to filter a list, among other things!
First and foremost let me say that the video is really good and for more than just the new check boxes. I always enjoy your videos and your courses, so thank you very much for taking the time to making this video!! An issue that seems to be a consistent one from the responses: When (if) I finally get it, it will be lost in history. It might be useful to "remind" us of this video when it more generally available. FYI - I am on the "insider" channel.
Cell iteration is an awesome tool, use it for a lot of modeling projects. Great video!
Great tutorial. Thanks so much Leila. This will help me switch from Outlook to-do or OneNote to the new Excel checkbox here. 😘
Watching any of your videos is like going to a restaurant and ordering one dish, but you get salad, drinks, and dessert for free. Thank you.
Thank you for your lovely feedback! It's wonderful to know our videos offer you so much value. Happy learning!
Thank you for the videos. I have been out of collage a long time (2004). I finally got my engineering tech position, and I have had to try to remember all the Excel stuff. Your videos have helped me a lot. I did this video as you showed it. It worked as yours did. Then I applied it to my annual task sheet which has 100 or so task lines, but only a few have projects listed in the projects/Tasks. The rest of the lines are blank. where the blank ones are there is a 0 on my not completed task list. I am guessing this is due to nothing being on the line, so it is a place holder. Is there a way to not have the 0 show if the line is blank? Thank you again.
So I love the ease of this. I created a spreadsheet to check on Quality Audits and get a score. Once done, I would love to clear it so I can start over on the next one. Is there a way to create a clear checkboxes when using the insert checkbox feature? Thank you for sharing your knowledge with us!
This could be super-useful. I can finally introduce something to our organization that I've been hoping to implement for years! I have two question: (1) If the checkbox is unchecked and re-checked, does the timestamp refresh? (2) Is it possible for the timestamp (or an adjacent cell) to indicate the name or initials of the person who checked the box?
This video is gold, just like the content creator.
I can see myself using this as a teacher for my digital attendance sheets...Thank you !!
Thanks for this great video on checkboxes ✅ Leila. Excel just keeps getting better with time 😊
This new feature helped me to use as checklist with auto formatting. Really nice feature. Thanks Leila Gharani
Is there any special version of 365 that this works in? I have Microsoft® Excel® för Microsoft 365 MSO (Version 2403 Build 16.0.17425.20124) 64-bitars, and here is not the Checkbox option.😔
It's currently still in Beta channel. You have to join Office Insider to get it now.
Excellent! I have been putting off some work involving checkboxes, and boy, am I glad I waited. This is a tremendous improvement. Thanks MS and Leila.
This video is packed with tips. Pure gold!
So much packed into one video! This is fantastic.
Glad you enjoyed it!
Ms. Leila! I am one of the "brilliant" students in your courses. This video comes just in time. However, I had to become an insider to follow the lesson. Otherwise, I would have waited for the live version.
That you have to "Join Office Insider" to get this to work is an issue that should really have been mentioned.
It's about time they fixed the checkboxes! Great video.
Yay, thank you!
Why is the checkbox feature not available on my Windows 11 computer? The checkbox feature I am talking about is here at the 1:39 mark. In order for me to add a checkbox in my Windows 11 I have to use the Developer option to add a checkbox however on Excel on my MacBook the Insert>checkbox is available
Great explainer! I have passed it along to a coworker. Your timestamp technique is very interesting; I'm going to ponder this approach.
Finally Microsoft!! Great video. Thanks for sharing. Is it possible to populate the profile of the account user who checked the box? Similar to what you see in Word when someone adds a comment. If this is possible, it would be a great way to track who completed what.
It could be very useful!!!
Maam You are Brilliant. The way you bundle with other options is superb
Thanks a lot
3 months later, many tutorials done, the thing has been tested all over the planet and is still not available to all O365 subscribers... worse buzz ever. Close to the deceptive advertising.
Fantastic video!
Pretty cool! Can't wait for it to roll out to the desktop!
"Mam your video has proven to be extremely helpful for our data career. We kindly request you to provide a link to the dataset so that we can practice immediately.
checkboxes? ... cute! .... but the real gem here is the automatic, permanent Timestamping!!! I have been trying to solve this for everrr (like 20 years) ... thanx so much Leila, this solves a problem for my team that has been a headache for a long long time!💕
Glad to know that we could help you overcome this challenge! 😊
Finally a REAL checkboxes as there are in google sheets. Shame that is only available in 365 for now, I have so many ideas to implement those in my workplace which has Office 2021
Dear Leila,
Thanks for the great video!
I am looking forward to using the new cool Checkbox feature.
I imagine I can apply this tool for my current course check task.
Quick question: I have a list of course to check whether they meet the numbers of requirements (ie, 10 elements).
- From the video, I can easy check the status of each course.
- However, I also want to record the status of each course before I check another one and be able to go back to previous course for status modification (ie, from not completed to completed).
=> Is it possible to set up this in Excel with Checkbox feature? Thanks for your advice on this.
I LOVED the idea to timestamp checkboxes.
Really cool video Leila !!! Targeted, Useful, Practical, Fun, all in one!!!!
@LeilaGharani, Thank you for this video. I was able to apply the timestamp trick you showed in the video and it worked!!!!! At first, I did it differently and each time I clicked the checkbox the whole time updated. But when I applied your method and applied iterative calculation check on it, it worked. Thank you, again.
Also, I was able to combine this checkbox on task done to my dynamic excel calendar. I have a separate sheet with tasks and dates (DDD, DD-MM-YYYY).
I have another sheet in the same workbook where I did a monthly calendar with a conditional Formatting highlighting Today's date which changes dynamically each day.
Beside the calendar I have a task list comprising of 10 tasks, a checkbox for completion, and a timestamp. I used the filter function to select tasks for the day from the task sheet to the calendar sheet and I tick them off when done.
Thank you once again for your lectures.
Thank you for the stunning video on checkboxes and their usefulness. My check box is not on the far right end of the ribbon. It's in a group by itself in the middle and the name of the group is "Control". But it seems to work the same. Why is that? Thank you so much in advance.
Thank you so much for all of your very helpful and professional videos! Any idea when the new checkboxes will roll out to the masses?
Glad you like them! Unfortunately, there is no fixed ETA from Microsoft. As far as I know they're still tweaking the functionality based on user's feedback.
This is a great tutorial. I plan on using it to keep track of a number of tasks that I have to complete to prepare for an upcoming surgery. I can see many uses for this type of tracking table. You explain things so well and it is easy to follow along..I had to update my version of MS 365 using the latest beta versions.
i think i will be using the checkbox timestamp. i have an excel spreadsheet that tracks user inputted date and time. this would make quick insertion work for the beginner user.