Using Checkboxes in Excel - Part 1

Подписаться 1,5 млн

Просмотров 668 тыс.

50% 1

Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to easily add checkboxes into your Excel spreadsheets. You'll also learn a more complicated method that allows you to link checkboxes to other cells in the spreadsheet. Here's the practice file for this video: bit.ly/employee... #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Part 2 of this video can be found here: • Using Checkboxes in Ex...

Хобби

Опубликовано:

20 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@MsGillian31 4 года назад

This was an excellent video that clearly and quickly explained this (in my opinion unnecessarily) complicated Excel process. I would greatly appreciate the conditional formatting/if tutorials. Thanks so much! (Is anyone else shocked that checkboxes aren't available in Excel when they are just standard automatic insert/true-false features in Google Sheets and Mac Numbers??)

@RJSAMCRO 4 года назад

I use Excel on a daily basis and I admit I am a beginner there are quite a few courses on here with people showing Excel but this is the clearest and not once did I have to pause and go back. Thank You for this channel

@deebaxley7800 4 года назад

I love how mail merge has evolved since I first used it 20 years ago. It's so much easier now. Another column header I *often* used for my boss was something personal within the letter for a specific individual (i.e., I enjoyed our golf game -- bla bla bla). Now retired I still use MM for my Christmas letters. LOL Love the way you explain, especially Excel... always learning something new.

@psrfpsrf 4 года назад

Best explanation I heard as nativ speaken German in English language. Excelent clear pronunciation.

@gusguillen5840 2 года назад

Thanks, really helpful. After wasting 20 minutes checking out confused and confusing RU-vid videos with endless chat, yours let me do it in in about 1 minute. I was doing it as I was watching.

@dressplaner 4 года назад

For a German like me excelellent and super clear spoken English and a cool voice. Thanks a lot.

@godwinuche4669 2 года назад

You will live long my great teacher. You are the best excel teacher online hands down. Please always remember to add the link file you are using for any particular example you are using so we can download and follow along. Thank you 🙏

@geraldAyieye 4 года назад

go ahead, we are waiting for the video on conditional formating. This is great

@mariannebecker5132 4 года назад

Yes please and thank you to show how to highlight some of the cells with conditional formatting and/or the “if” statement

@kieronstirrup 4 года назад

I have found these lessons to be extremley helpful and are clear and easy to understnad, even to a non computer competent person like me. Great work and thank you!

@grahamhughes3653 4 года назад

Great explanation Video please for conditional formatting

@adammorgan7256 2 года назад

Nice vid and thanks for posting! Its been a while since you posted this, but in case you haven't figured this out yet - at 7:15 when you're editing each cell that shows $G$2, you can edit this to $G2 and drag it down over the below cells. $G$2 will always lock to that exact cell, whereas $G2 will lock to the column, and G$2 will lock to the row. You can easily amend this by pressing F4, and it will cycle between each lock type. :)

@h82fail 2 года назад

This works for you? I can set cell link to G2, $G2 etc and when I autofill they are still all the same - all check the same and are linked to that single cell. Came to this video hoping there was another trick he was going to show and am disappointed that you really have to manually set all the cell links or use a macro? Seems stupid, google sheets works with check boxes without all the bs. Other oddness: if I autofill, then change the top checkbox and autofill again - the lower cells autofilled will have checkboxes over checkboxes - it doesn't replace the old ones it just adds a new one over the old ones. So I guess you should delete the old ones first then right - selecting the cells and hitting delete doesn't remove them. Right clicking to select them, and hitting delete still doesn't remove them for me?! The only way to remove a checkbox I found is to right click to select it, and then hit cut?? Why does excel handle check boxes so poorly.

@AP-eb8hd Год назад

This doesn't work

@jaclee6159 2 года назад

Thank you. This video is clear and easy to understand with well neat visuals. It's easy to follow with reasonable length of time.

@raiders100 4 года назад

Conditional formatting and “if” functions please!

@jeffs9003 4 года назад

He has a "if" function video

@empirebullionmint2356 2 года назад

Thank you . Super helpful. Such a simple thing to do but I wasted 20 minutes trying to figure it out.

@asm1795 3 года назад

For 3d check box, just delete $ for reference cell number ( $G3). Then flash fill would work hope fully.

@dixiefolzenlogen5326 2 года назад

I tried that and it did not work.

@subhashthangadipally4974 3 года назад

Maybe I came late your platform but yahh... I Really blessed.. and Iam new subscriber.

@jeffs9003 4 года назад

Really like all your excel videos, very nice so helpful.

@isabellemagis8276 Год назад

You are an excellent teacher, great voice, great pace and so very clear! I would very much appreciate a video on conditional formatting and if tutorials. I know there are many about, but for some reason I am finding it difficult to understand, whereas your video was so very clear. Keep on going!

@gregharrison3886 4 года назад

Your videos are amazing, thank you. So many excel and computer related videos out there that are such poor quality. A1

@walala5020 2 года назад

I have zero experience in Macro, but you made it so easy for me to understand and use it now, thanks you so much!

@querrythis 2 года назад

I had a hard time getting it in the cell I wanted, it drove me nuts. Thanks for you valued help.

@rayvortines 2 года назад

Thanks brother, I can use it at work

@DNin210 4 года назад

Great video! Thanks for creating. Very easy to follow, nice pace, showed each step, and spoke clearly. Excellent work and very helpful!

@franciscopacogonzalez527 2 года назад

I like the way you explain, it is very clear and right to the point

@mariafernandagonzalezesilv5106 Месяц назад

Thank you for this video. Was very easy to follow.

@PapaDukesFl 4 года назад

Great video, and yes I would to learn more about how to use conditional formatting to highlight various cells. Change colors etc..

@sasavienne 4 года назад

*You are amazing.* *Thanks a lot for this truly nice tutorial.* 🌟 🌟 🌟

@vthiryone7882 4 года назад

Pls.. Make a video for conditional formatting using the check box

@michelletmy8858 2 года назад

Clear and concise lesson. Thank you very much.

@noctoi 2 года назад

Oooh thank you. Thank you thank you. This is EXACTLY what I needed!

@lawrettachinenye8725 4 года назад

Your videos has been soooo helpful... Thank u dear

@thealand-a3769 4 года назад

Thank you please keep making these excel

@user-cp8ir5wn2r Год назад

thanks ,,,greeting from Sudan

@amarachiokpechi4316 4 года назад

I think it would be better if all your videos were orderly published, it will help for easy access so as to know where to start from and where to continue from.

@PaulyGirl48 4 года назад

Conditional Formatting and if then lesson would be great!

@sirjo-emtv8134 4 года назад

PLEASE make a video how to check quizzes, test or exam with MS excell

@marikat-tr2wi 5 месяцев назад

Thank you, it is very informative lesson, you are outstanding instructor. Elena

@ahmednaser7867 Год назад

Please keep going. You are so good

@khushhalpakistanzindabad4680 4 года назад

On linking the check box, you can remove the "$" sign before the row# and then you can copy all the way down.

@jamesfarnham1976 4 года назад

Looking forward to more videos! Thank you!! Jim.

@FairoosAAzeez 2 года назад

you are amazing, great explanation

@kristyportwood7107 3 года назад

Great information and easy to follow. yes please make conditional and if video.

@glisten_skin 3 месяца назад

You're not pregnant but you always deliver😫🙌

@kausarjawaid886 4 года назад

Very nice. Yes please do make follow up video

@techteachersandstudents 4 года назад

Here's the follow up video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LVu3E64w1-k.html Thanks for watching!

@roughshot1021 2 года назад

Thanks brother your save me some time and frustration - Your the Man :)

@adonaimelandrovitamog8776 4 года назад

Remove the $ sign before the number Example $F2 and so on. Then copy so that I won't do it manually.

@Just-My-Opinion 4 года назад

can you confirm that it works? it is not working for me. I know thats how excel normally handles these type of references but its not working for form controls or active x ones

@nekeem.3540 4 года назад

doesn't work for me :(

@binsh3el 4 года назад

@@nekeem.3540 Remove $ and select F2 & G2 then drag them together, or do F2,G2 & F3,G3 then select them all & drag, if it doesn't work just sell your laptop.. LOL

@xuanqinglong 3 года назад

tried it and it didn't work

@B-Line1234 3 года назад

Just run this macro and it will work : Sub LinkCheckBoxes() Dim chk As CheckBox Dim lCol As Long lCol = 2 'number of columns to the right for link For Each chk In ActiveSheet.CheckBoxes With chk .LinkedCell = _ .TopLeftCell.Offset(0, lCol).Address End With Next chk End Sub

@fionaleonard7229 4 года назад

Conditional formatting and if formulae would be great.

@jeffs9003 4 года назад

He has both of them

@karammazin6413 2 года назад

very good , excellent teaching method

@anupsebastian7250 4 года назад

yes.good one.Please do a follow up video as well.Thank you.

@amalrajraj8942 3 года назад

Simply brilliant and excellent teaching, Great

@user-tc5pl3zw3h 5 месяцев назад

This was very helpful. I'm still trying to figure out how to get the controls to move and size with the cell they're in. In my Format options for the check box, it is disabled.

@Thedirtyprawn 4 года назад

yes plz id like to know how to have the cells highlighted also these vids are very helpful cheers

@captdave1961 4 года назад

Is it possible to make a check box that has button characteristics when checked?

@pawjeppesen-ifttttricks605 4 года назад

Wold love to see the video on corneal formating, is's exactly what I need for a project! //Paw

@benjaminruba5022 3 года назад

You have made me to know some thing which i have never known thanks for the video

@CihanSan 2 года назад

Thanks for the tutorial!

@user-yk8bm7fv9d 4 года назад

PLZ, re-order the videos according to their publishing date, CUZ I feel confused which one published before the previous one. ❤️ Thanks for your efforts.

@chriss2352 5 месяцев назад

Wonderful, thank you! Subbed

@robhimself33 2 года назад

Wow that's a shame Excel doesn't have better functionality for this, was hoping to use it for a large spreadsheet of 800+ records. That said super informative video, I now know how to use this for smaller tasks if needed.

@rajeevgosavi4514 4 года назад

GREAT VIDEO, NICELY EXPLAINED. SIR WE WOULD CERTAINLY BE INTERESTED IN YOUR VIDEO OF CONDITIONAL FORMATTING WITH IF FUNCTION, LOOKING FORWARD TO IT.

@vashlyruiz3310 Год назад

Thanks for the info

@stevebayt145 9 месяцев назад

theres a video somewhere that shows how not to do each individual form entry one at a time. to update the cell reference.

@reece-diesel 3 года назад

Amazing information dude. Thank you

@palawenavibe1951 3 года назад

Hello. Im an HR Personnel. Thank you for this. It helped alot doing my database for teachers' dtr submission. Question though, how could i delete all checkboxes in shortcut? thanks again.

@nitinnarkhede1973 3 года назад

Thank you very much

@BARTLANTV 3 года назад

nice and very informative video,,, thnks for uploading this...

@canningmatthew 3 года назад

Yes please re if and conditional formatting please!

@anniewalker5340 4 года назад

Hi , Teacher, I definitely want to have a following up video pertaining to how to make highlights, if functions and conditional formats Look forward to hearing from you soon. Br Annie

@karrenhackling6238 4 года назад

Showing coloured boxes would be great thank you.

@aumailanoral-deen5093 3 года назад

thankx for your video i try do insert check list in excel and must work in android dives phone or tablet

@charmaleehoward9010 4 года назад

The conditional formatting video would be appreciated. Thanks

@samanthaspencer2499 4 года назад

Thank you! This helped so much.

@nengtech6914 4 года назад

Awesome tip

@christianplaner-schlatzer6607 3 года назад

Hi, you can release the cell to be fixed using F4 key. The. You see the Dollars are removing, when you then drag and rip the check boxes down, then the linked cell is also moving down. Hope I explained good enough.

@paramasivamsadagopan2581 4 года назад

Nicely explained.

@hizzyvoltaire3764 4 года назад

In Excel preceding the cell id with a $ makes it absolute rather than relative, so when you copy a function with the reference B2 to the next row it becomes B3, similarly if you copy B2 to the next column it would be come C2. If a $ prefix is used then they reference will remain static when copied, $B$2 copied to another location would remain $B$2; if $B2 copied to another row/column would remain $Bn, if B$2 were copied to another row/column, it would be x$2,

@MartinaDzulovska 2 года назад

this doesnt work. it copies still the same cell. I think the only way is to do that with macro.

@alexcn 4 года назад

Fantastic video. I just curious if you delete $ in that formula it will work well to make a massive of checkboxes?

@overlandsubaruinternationa2378 2 года назад

thanks for this

@prasannarana9602 4 года назад

do you have videos where I can learn those little programming stuffs like if statements more?

@lailamaly7522 4 года назад

Thank you for this! Exactly what I needed - and it was so easy to follow!

@Johantheman 4 года назад

If you remove the $ signs from the first entry in the G column could you not then drag the true false formula?

@Johantheman 4 года назад

Hmmm. Doesn’t seem to work!

@xyyamcavadov4280 Месяц назад

Thanks

@georgeregoo 4 года назад

You can just remove the $ before the two and then autofill down the line. Have you tried that For check boxes

@clashofclans4314 4 года назад

I don't know how he is not aware of that

@carolinecarriere5505 4 года назад

Not working.

@Hamza-ci8wz 3 года назад

Not working

@allabout1135 4 года назад

Is it some other way how to deal with linked cell issue? Manually addjusting is to crazy.

@lrojas26 4 года назад

I absolutely love working inside Excel, however, Google Sheets version of the checkbox eats Excel for breakfast.

@chilingringa2767 3 года назад

I've been googling for an hour trying to figure out how to use Excel check boxes like Google sheets.

@STanimer17 4 года назад

IF AND COLOR PLEASE!

@Triskalon 3 года назад

Could you not just get rid of the "$"s before you auto fill?

@Roadyheid 3 года назад

Exactly. 👆

@Pankaj-Verma- 4 года назад

Thank you so much for your kind help!

@mehappym 2 года назад

Thank you for this video,. I would like to use check boxes to use on a check list. And how can I lock certain cells and only unlock only if checkbox is ticked. so its a step by step process . I tick first check box than only next cell gets unlocked and so on. Is that possible?

@paulferguson825 6 месяцев назад

You don't actually have to update each linked cell reference... Just delete the $ signs from the cell reference and it will automatically change for you...

@johnstiven2023 Год назад

For the second style of check box, if you take away the $ before the number and then copy down, surely this will enable you to not have to change each number individually?

@drleowcs32 4 года назад

Very good and thanks

@yassinehistoirecivil-patr1587 4 года назад

Yeah beautiful 👌🏻

@carlosspaniard 3 года назад

When I use check Boxes I link to the same cell and format those cells with ;;; and True or false will be invisible and still works to apply conditional formatting no need to hide cells!

@anubhavdatta2363 Год назад

Can you please show how to delete them? It seems I can't remove the boxes using clear all or content or through delete key

@MyDMcA 2 года назад

If you remove the $ before the 4 in G4, when you copy wouldn't it change it for all the rows?

@mazexholdingllc1942 4 года назад

Hello I have data that requires having a checkbox with two options which "Granted or Withold". The data was created in Excel 2016. Could you give a tutorial on how to do a checkbox with two options as mentioned? Regards Arif Shaikh