Using Checkboxes in Excel

Using Checkboxes in Excel - Part 1

Рет қаралды 665,108

Technology for Teachers and Students

4 жыл бұрын

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/employeecheckboxes #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...

Пікірлер: 236

@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.

@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 🙏

@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

@DNin210 4 жыл бұрын

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

@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!

@mariannebecker5132 4 жыл бұрын

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

@PapaDukesFl 4 жыл бұрын

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

@psrfpsrf 4 жыл бұрын

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

@geraldAyieye 4 жыл бұрын

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

@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!

@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.

@dressplaner 4 жыл бұрын

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

@lailamaly7522 3 жыл бұрын

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

@pawjeppesen-ifttttricks605 4 жыл бұрын

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

@sasavienne 4 жыл бұрын

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

@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

@PaulyGirl48 4 жыл бұрын

Conditional Formatting and if then lesson would be great!

@jeffs9003 4 жыл бұрын

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

@franciscopacogonzalez527 2 жыл бұрын

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

@michelletmy8858 2 жыл бұрын

Clear and concise lesson. Thank you very much.

@amalrajraj8942 3 жыл бұрын

Simply brilliant and excellent teaching, Great

@gusguillen5840 2 жыл бұрын

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

@jamesfarnham1976 4 жыл бұрын

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

@lawrettachinenye8725 4 жыл бұрын

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

@thealand-a3769 4 жыл бұрын

Thank you please keep making these excel

@grahamhughes3653 4 жыл бұрын

Great explanation Video please for conditional formatting

@samanthaspencer2499 4 жыл бұрын

Thank you! This helped so much.

@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!

@GrenPara 2 жыл бұрын

Hello, Great video thanks for making it. I do have a question, when inputing data into fields and I come to the check box, is there a way to make it so spacebar toggles the check box for that field? So space checked, space again unchecked, without have to always click the box.

@raiders100 4 жыл бұрын

Conditional formatting and “if” functions please!

@jeffs9003 4 жыл бұрын

He has a "if" function video

@Pankaj-Verma- 4 жыл бұрын

Thank you so much for your kind help!

@docokd7oco443 4 жыл бұрын

If you just need a simple yes/no checkmark you could change the font to marlette for that column and simply type the lower case 'a' which gives a checkmark. You can then use that letter for any needed additional structs or conditional formatting or ???. No messy additional changes to a fussy form tool.

@gregharrison3886 4 жыл бұрын

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

@noctoi 2 жыл бұрын

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

@mariafernandagonzalezesilv5106 28 күн бұрын

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

@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

@marikat-tr2wi 5 ай бұрын

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

@prasannarana9602 4 жыл бұрын

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

@anupsebastian7250 4 жыл бұрын

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

@almoatasemalhashmi341 4 жыл бұрын

Hi! I'm using Excel for Mac, and I can't just drag the cell to make more checkboxes. Is there a way to do it on mac? Thanks

@reece-diesel 3 жыл бұрын

Amazing information dude. Thank you

@kristyportwood7107 3 жыл бұрын

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

@melissahollister1405 3 жыл бұрын

Can you have Excel automatically insert a checkmark on a sheet when specific text data is entered into a budget spreadsheet? ex: one spreadsheet has vendor accounts listed with boxes to check when that monthly payment is made & entered into a different spreadsheet. Hope this isn't confusing.

@querrythis 2 жыл бұрын

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

@subhashthangadipally4974 3 жыл бұрын

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

@empirebullionmint2356 2 жыл бұрын

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

@Thedirtyprawn 4 жыл бұрын

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

@ithirstyforknowledge 4 жыл бұрын

I really liked your video and would love to see the conditional formatting applied. Thanks so much!

@vthiryone7882 4 жыл бұрын

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

@georgetosounidis5545 4 жыл бұрын

thanks a lot for this! Subscribed

@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.

@BARTLANTV 3 жыл бұрын

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

@paramasivamsadagopan2581 4 жыл бұрын

Nicely explained.

@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 3 жыл бұрын

@@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

@ashutoshmehta8689 4 жыл бұрын

Can you use check Box, to order Excel to copy certain cells of that perticular raw?

@CihanSan 2 жыл бұрын

Thanks for the tutorial!

@roughshot1021 2 жыл бұрын

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

@karrenhackling6238 4 жыл бұрын

Showing coloured boxes would be great thank you.

@FairoosAAzeez Жыл бұрын

you are amazing, great explanation

@captdave1961 3 жыл бұрын

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

@karammazin6413 2 жыл бұрын

very good , excellent teaching method

@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.

@ahmednaser7867 Жыл бұрын

Please keep going. You are so good

@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!

@amoledor 4 жыл бұрын

If you hide the column with the "True/False," will the conditional formatting still work if conditional formatting is applied?

@benjaminruba5022 3 жыл бұрын

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

@hadeerashraf2384 4 жыл бұрын

thank you, big help .

@FoodInDaHood 4 жыл бұрын

Hello. Is it possible to add the date and time when the check box was ticked in the next column?

@carolinazhang1593 4 жыл бұрын

how to download the excel sheet so that I can practice accordingly ?

@wvooijen 4 жыл бұрын

Thanks again can't wait for the rest ;-)

@vashlyruiz3310 Жыл бұрын

Thanks for the info

@chriss2352 4 ай бұрын

Wonderful, thank you! Subbed

@yassinehistoirecivil-patr1587 4 жыл бұрын

Yeah beautiful 👌🏻

@rayvortines 2 жыл бұрын

Thanks brother, I can use it at work

@user-cp8ir5wn2r Жыл бұрын

thanks ,,,greeting from Sudan

@lenois18 4 жыл бұрын

Very informative. 😘

@drleowcs32 4 жыл бұрын

Very good and thanks

@TheWannabeGeek 4 жыл бұрын

If u removed the $ from the cel reference that should allow u to update subsequent cell?

@nitinnarkhede1973 3 жыл бұрын

Thank you very much

@allabout1135 4 жыл бұрын

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

@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

@suleimana678 Жыл бұрын

Hi, is there a way to checkmark the box using the keyboard (instead of needing to left click on the mouse)? I tried using the space-bar but to no avail (i.e. the space-bar works for Google Sheets I see).

@kausarjawaid886 4 жыл бұрын

Very nice. Yes please do make follow up video

@techteachersandstudents 4 жыл бұрын

Here's the follow up video: kzfaq.info/get/bejne/grylZqhnmd2VXZ8.html Thanks for watching!

@theadraalexander7198 4 жыл бұрын

Good teacher

@nengtech6914 4 жыл бұрын

Awesome tip

@alexcn 4 жыл бұрын

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

@charmaleehoward9010 4 жыл бұрын

The conditional formatting video would be appreciated. Thanks

@kar2194 3 жыл бұрын

Question: How can I remove the column of the check boxes? Conventional column removal doesn't work as well as copying a white blank cell pasting on the entire check-box column also doesn't work. It will be absolutely fantastic if I can perform this. Thanks for such a helpful video!

@Fansporty 4 жыл бұрын

Great.

@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.

@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.

@user-tc5pl3zw3h 4 ай бұрын

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.

@overlandsubaruinternationa2378 2 жыл бұрын

thanks for this

@fionaleonard7229 4 жыл бұрын

Conditional formatting and if formulae would be great.

@jeffs9003 4 жыл бұрын

He has both of them

@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?

@moniamasti 3 жыл бұрын

How do we create graphs which shows certain things are updated or not based on the check box

@kishoreyc 4 жыл бұрын

Under format control can you not change the cell reference and copy it down in column G?

@canningmatthew 3 жыл бұрын

Yes please re if and conditional formatting please!

@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?