Excel's NEW Checkboxes Are Incredibly Cool! Here's why

Excel's NEW Checkboxes Are Incredibly Cool! Here's why

Leila Gharani

8 месяцев назад

506,098 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Hyd 12
Hyd 12 - 23.11.2023 21:16

If I share the file to someone or host it on SharePoint, should the other user also enable the iterative calculation for the timestamp to work or will the specific file retain that setting.

Ответить
Bento's Matrix
Bento's Matrix - 23.11.2023 19:43

Has this reached the stable channel or still in the dev channel?

Ответить
Benjamin Dickert
Benjamin Dickert - 23.11.2023 13:43

About the timestamps:
If you close and reopen the file, the current time is entered and not the time at which the checkbox was clicked. Or am I wrong?

Ответить
JimRegney
JimRegney - 23.11.2023 12:51

Thanks for the great ideas. Currently I can‘t find it in my excel. Should I activate it anywhere? Greetings from Germany

Ответить
Niv Krayner
Niv Krayner - 23.11.2023 11:59

What version does this function appears in? I don't have it in my "Insert" ribbon

Ответить
Ayman Khaleel
Ayman Khaleel - 23.11.2023 11:35

I can not find the checkbox tool in the ribbon, The only way I can access it is through the Developer Tab and insert from within that TAB. However, this does not give the same functionality as you show in this tutorial, i.e. when the box checked or not it does not return the "true" or "False" in the input bar!

Ответить
Kossivi AGLEE
Kossivi AGLEE - 23.11.2023 10:43

Thanks for the video but in my 365 office, I do have the Checkbox tab but not the command. Please, what should I do?

Ответить
AXNJXN1
AXNJXN1 - 23.11.2023 06:36

Thank you Leila, very impactful video! Question however. The inserted 'shapes; is there a way to make such items as these 'stamped' or semi permanent on the sheet so if it's passed around the office no one can move these objects? Additionally, can you lock these components down and the hidden portions so only the clickable areas of the checkboxes are 'useable'? Again, so as a front end, people could interface it, but not 'change' the look/setup of all that was in this video?

Ответить
Rod Winning
Rod Winning - 23.11.2023 03:35

Not available for Mac yet?

Ответить
Scott's Outdoor Channel
Scott's Outdoor Channel - 23.11.2023 00:04

Hi I am using office 365 personal fully updated, but I don't have the Cell Controls tab, nor do i have the option to add it nor are the new check boxes available. Do I need a different plan or something? Please help, this isn't the first time you have shown something cool that I was not able to access.

Ответить
Renato Vianello
Renato Vianello - 22.11.2023 19:31

Hi Leila, many thanks for your wonderful posts!
I'd ask you a question: using the NOW function the date stamp won't chanche tomorrow?

Ответить
Desunia Hardware
Desunia Hardware - 22.11.2023 16:10

It's remarkable how much information she can fit into 15 minutes. Well done!

Ответить
Tertius
Tertius - 22.11.2023 14:47

I don’t have that function yet 😢

Ответить
CLN SL8
CLN SL8 - 22.11.2023 14:42

Omg wow

Ответить
Khurram Ilyas
Khurram Ilyas - 22.11.2023 13:59

I have office 365 but there is no checkbox option in insert.. I found the check Box in customize ribbon option but there are 2 check box options which one I need to use ?

Ответить
Pascal Bouman
Pascal Bouman - 22.11.2023 13:48

Hi, I'm using the Beta version but can't find this button. Do I have to do anything extra?

Ответить
Moris Lubin
Moris Lubin - 22.11.2023 13:24

Nice clear neat video ❤

Ответить
Nehul_1991
Nehul_1991 - 22.11.2023 10:46

Thank you, will implement right away for my monthly checklist

Ответить
PizzaPete1958
PizzaPete1958 - 22.11.2023 09:05

Fantastic video!

Ответить
Joshua Moreno
Joshua Moreno - 22.11.2023 08:31

When is this coming out of beta?

Ответить
satyaban sahoo
satyaban sahoo - 22.11.2023 08:12

This feature in beta version or available to masses already?

Ответить
Jaco Kemp
Jaco Kemp - 22.11.2023 08:05

Great video, thanks! Could someone please walk me through how Excel actually evaluates that iterative function so that the now() function is returned, but not re-evaluated every time something else in the sheet changes? Not quite clear on that (or how iterative functions work in general :-) ).

Ответить
Andi
Andi - 22.11.2023 07:34

On timestamp cells, can you just use =IF(C5=true,Now(),"") instead?

Ответить
siva prakash
siva prakash - 22.11.2023 05:45

Is this work any other microsoft office version except 365

Ответить
Guilherme F.
Guilherme F. - 22.11.2023 02:34

Is this available for excel 365? I just updated my software, and this option don't exist between the "Comment" and "Text Box" sections. When I go to Options > Customize Ribbon > Main Tabs, the "Cell Controls" section is empty

Ответить
Aleco Savvas
Aleco Savvas - 22.11.2023 01:25

Hi Leila, if we have updated excel what other reason could be causing our checkbox to still appear in the old format?

Ответить
@ Shanghai
@ Shanghai - 22.11.2023 00:56

Thank you Leila...

Ответить
Frost
Frost - 22.11.2023 00:08

I am a subscriber of Microsoft 365 Personal and I still don't have it. Can anyone tell me when this checkbox will be available on my ribbon?

Ответить
Josef Nitzborn
Josef Nitzborn - 21.11.2023 23:18

Hi Leila, some cool features... Can't wait to use them.

I struggled today to extract a sheet name into a sheet on Excel Web of 0365.

Hope you can help... May there are existing links.

Ответить
MrYdoineedthis
MrYdoineedthis - 21.11.2023 20:49

These are great, and much better than current options and work arounds. Can we enable this Beta feature in current versions? or do I have to wait for these checkboxes? 😢

Ответить
Barackuse
Barackuse - 21.11.2023 20:30

This must be only in the beta version. My 365 (Enterprise) does not have this feature.

Ответить
Phillip de Leon
Phillip de Leon - 21.11.2023 20:26

🤯🤯🤯
👏👏👏

Ответить
Chandan Kumar
Chandan Kumar - 21.11.2023 20:14

Madam, your explanation is always awesome.

Ответить
George Milios
George Milios - 21.11.2023 18:14

I can't find this option. I have the "Microsoft® Excel® για το Microsoft 365 MSO (Έκδοση 2310 Build 16.0.16924.20054) 32 bit ", do you know where can I find it?

Ответить
Alessandro
Alessandro - 21.11.2023 16:37

welcome to 2014

Ответить
The Truth
The Truth - 21.11.2023 15:21

2.44 million subscribers. Wow

Ответить
Faysal Easy Excel
Faysal Easy Excel - 21.11.2023 14:26

this is just awesome

Ответить
Brian McGovern
Brian McGovern - 21.11.2023 12:16

why does my version of excel not show the insert checkbox in insert tab? I have to go to developer and insert check box as a form control or activex control and does not behave the same way and I cannot select multiole cells and insert check boxes in all of them at the same time

Ответить
Rabel Masud
Rabel Masud - 21.11.2023 11:25

I'm not getting a checkbox in the insert tab, could you please advise how can I add it, thank you.

Ответить
RiffteeRidmee
RiffteeRidmee - 21.11.2023 11:15

Would you please share this working sheet.

Ответить
John Crighton
John Crighton - 21.11.2023 11:02

Excellent tutorial!

Ответить
Daniel Kwek
Daniel Kwek - 21.11.2023 04:38

I needed to turn on my Developer settings. But even then, my check box looks different than yours. And tick itself looks very pixelated. Why is that?? I'm on 365 Personal package.

Ответить
Casos Baya
Casos Baya - 21.11.2023 04:12

MS need to release this now

Ответить
Todd Bellows
Todd Bellows - 21.11.2023 03:25

I learned how to use pen & paper to make a to do list then scratch the items off as they were completed. works well.

Ответить
Jim Reid
Jim Reid - 21.11.2023 01:27

Great tutorial and really useful. However, the checkbox function is not showing on my my excel as per the tutorial. Would anyone know why?

Ответить
Rick Hyne
Rick Hyne - 20.11.2023 22:57

I don't have the checkbox option on Office 365

Ответить
justbram
justbram - 20.11.2023 21:48

Finally!!!!!

Ответить
Humaon Limon
Humaon Limon - 20.11.2023 21:03

Love to watch your learning videos.

Ответить