Using Checkboxes in Excel - Part 1

[@MsGillian31]

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]

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]

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]

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

[@geraldAyieye]

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

[@gusguillen5840]

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

[@dressplaner]

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

[@godwinuche4669]

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 🙏

[@kieronstirrup]

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!

[@adammorgan7256]

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]

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

[@mariannebecker5132]

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

[@raiders100]

Conditional formatting and “if” functions please!

[@jeffs9003]

He has a "if" function video

[@grahamhughes3653]

Great explanation Video please for conditional formatting

[@jaclee6159]

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

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

[@DNin210]

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

[@empirebullionmint2356]

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

[@walala5020]

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

[@jeffs9003]

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

[@PapaDukesFl]

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

[@querrythis]

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

[@vthiryone7882]

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

[@subhashthangadipally4974]

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

[@franciscopacogonzalez527]

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

[@lawrettachinenye8725]

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

[@thealand-a3769]

Thank you please keep making these excel

[@sasavienne]

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

[@noctoi]

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

[@gregharrison3886]

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

[@mariafernandagonzalezesilv5106]

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

[@PaulyGirl48]

Conditional Formatting and if then lesson would be great!

[@michelletmy8858]

Clear and concise lesson. Thank you very much.

[@jamesfarnham1976]

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

[@marikat-tr2wi]

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

[@asm1795]

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

[@dixiefolzenlogen5326]

I tried that and it did not work.

[@kristyportwood7107]

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

[@amarachiokpechi4316]

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.

[@roughshot1021]

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

[@karammazin6413]

very good , excellent teaching method

[@ahmednaser7867]

Please keep going. You are so good

[@adonaimelandrovitamog8776]

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

[@Just-My-Opinion]

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]

doesn't work for me :(

[@binsh3el]

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

tried it and it didn't work

[@B-Line1234]

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

[@anupsebastian7250]

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

[@BARTLANTV]

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

[@amalrajraj8942]

Simply brilliant and excellent teaching, Great

[@prasannarana9602]

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

[@kausarjawaid886]

Very nice. Yes please do make follow up video

[@techteachersandstudents]

Here's the follow up video: kzbin.info/www/bejne/gofYZHhsadxkY80 Thanks for watching!

[@rajeevgosavi4514]

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

[@alexcn]

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

[@captdave1961]

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

[@fionaleonard7229]

Conditional formatting and if formulae would be great.

[@jeffs9003]

He has both of them

[@FairoosAAzeez]

you are amazing, great explanation

[@reecediesel-1]

Amazing information dude. Thank you

[@pawjeppesen-ifttttricks605]

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

[@sirjo-emtv8134]

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

[@khushhalpakistanzindabad4680]

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

[@benjaminruba5022]

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

[@rayvortines]

Thanks brother, I can use it at work

[@canningmatthew]

Yes please re if and conditional formatting please!

[@aumailanoral-deen5093]

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

[@chriss2352]

Wonderful, thank you! Subbed

[@charmaleehoward9010]

The conditional formatting video would be appreciated. Thanks

[@user-tc5pl3zw3h]

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.

[@glisten_skin]

You're not pregnant but you always deliver😫🙌

[@الطيبمحمودحمد]

thanks ,,,greeting from Sudan

[@karrenhackling6238]

Showing coloured boxes would be great thank you.

[@samanthaspencer2499]

Thank you! This helped so much.

[@palawenavibe1951]

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.

[@Thedirtyprawn]

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

[@Johantheman]

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

[@Johantheman]

Hmmm. Doesn’t seem to work!

[@paramasivamsadagopan2581]

Nicely explained.

[@georgeregoo]

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

[@clashofclans4314]

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

[@greenmanislife]

Not working.

[@Hamza-ci8wz]

Not working

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

[@christianplaner-schlatzer6607]

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.

[@vashlyruiz3310]

Thanks for the info

[@hizzyvoltaire3764]

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]

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

[@lailamaly7522]

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

[@carolinazhang1593]

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

[@mehappym]

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?

[@bastange8856]

7:25 Why not just remove the dollar signs when assigning the first cell to reference when making the checkbox, now when you drag down, the reference box should move with the other cells down. In theory it should do everything correctly without the need of altering everything after dragging down.

[@fffinga]

That doesn't work for me. If you were successful, please share the steps

[@bastange8856]

@@fffinga Apparantly for some arsinine reason excel does not function as it normally does in this instance, you're stuck with the method described in the video. I'm fairly sure it's more of a bug than an intended outcome from the excel team though.

[@يوسفلؤيجودي]

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.

[@anniewalker5340]

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

[@robhimself33]

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.

[@shespeaks1971]

I'm going to watch your part 2. In this example, you can't sort and the checkbox will follow the employee row right?

[@ithirstyforknowledge]

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

[@kishoreyc]

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

[@lenois18]

Very informative. 😘

[@TheWannabeGeek]

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

[@allabout1135]

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

[@brijsden]

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

[@layaalmubayed]

Can you talk about printing in Microsoft ward please???

[@Noc4ball]

Lol?

[@nengtech6914]

Awesome tip

[@djmatter98]

Is there a way to use Form Controls on Excel for the web?

[@Pankaj-Verma-]

Thank you so much for your kind help!

[@astan2668]

Please is there a way to make the case a bit larger so she fits ?

[@GrenPara]

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.

[@nitinnarkhede1973]

Thank you very much

[@fasttrafficsolutions1649]

Can you change the true or false option after selecting the box to something else ..?

[@jessieramirez304]

Can you do this on Excell office or does it have to be excell business or excell student? I’m am looking to purchase this computer program.

[@melindam2776]

Wouldn't it resolve the issue if you temoved the $ sign in front of the row number at 5:48?

[@techteachersandstudents]

Yes, you're right.

[@mazexholdingllc1942]

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