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.

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

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

[@dressplaner]

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

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

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

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

[@DNin210]

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

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

[@grahamhughes3653]

Great explanation Video please for conditional formatting

[@jeffs9003]

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!

[@PapaDukesFl]

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

[@empirebullionmint2356]

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

[@subhashthangadipally4974]

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

[@querrythis]

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

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

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

[@franciscopacogonzalez527]

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

[@gregharrison3886]

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

[@lawrettachinenye8725]

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

[@vthiryone7882]

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

[@thealand-a3769]

Thank you please keep making these excel

[@sasavienne]

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

[@alexcn]

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

[@noctoi]

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

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

[@michelletmy8858]

Clear and concise lesson. Thank you very much.

[@captdave1961]

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

[@jamesfarnham1976]

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

[@prasannarana9602]

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

[@mariafernandagonzalezesilv5106]

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

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

[@khushhalpakistanzindabad4680]

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

[@PaulyGirl48]

Conditional Formatting and if then lesson would be great!

[@kristyportwood7107]

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

[@marikat-tr2wi]

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

[@roughshot1021]

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

[@BARTLANTV]

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

[@amalrajraj8942]

Simply brilliant and excellent teaching, Great

[@karammazin6413]

very good , excellent teaching method

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

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

[@ahmednaser7867]

Please keep going. You are so good

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

[@benjaminruba5022]

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

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

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

[@sirjo-emtv8134]

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

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

[@rayvortines]

Thanks brother, I can use it at work

[@anupsebastian7250]

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

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

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

[@FairoosAAzeez]

you are amazing, great explanation

[@TheWannabeGeek]

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

[@pawjeppesen-ifttttricks605]

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

[@glisten_skin]

You're not pregnant but you always deliver😫🙌

[@reecediesel-1]

Amazing information dude. Thank you

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

thanks ,,,greeting from Sudan

[@rajeevgosavi4514]

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

[@djmatter98]

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

[@Thedirtyprawn]

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

[@almoatasemalhashmi341]

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

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

[@kishoreyc]

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

[@brijsden]

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

[@fionaleonard7229]

Conditional formatting and if formulae would be great.

[@jeffs9003]

He has both of them

[@fasttrafficsolutions1649]

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

[@carolinazhang1593]

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

[@aumailanoral-deen5093]

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

[@paramasivamsadagopan2581]

Nicely explained.

[@chriss2352]

Wonderful, thank you! Subbed

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

[@vashlyruiz3310]

Thanks for the info

[@canningmatthew]

Yes please re if and conditional formatting please!

[@astan2668]

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

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

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

[@charmaleehoward9010]

The conditional formatting video would be appreciated. Thanks

[@samanthaspencer2499]

Thank you! This helped so much.

[@amoledor]

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

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

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.

[@ashutoshmehta8689]

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

[@arntrokstad2043]

I have made a document with checkboxes, which works well. But, I want to share the checklist via Sharepoint, so I can fill in the checkboxes via my Ipad. I can open the excel sheet on the iPad, but I do not get the checkboxes, and can not fill out the checklist on the iPad. Do you have any tips on how I can solve this

[@FoodInDaHood]

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

[@nengtech6914]

Awesome tip

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

[@karrenhackling6238]

Showing coloured boxes would be great thank you.

[@ahmadfawadfatan3015]

I have a quick question, is it possible that we change the true and false with our own customized words? If it is possible could you please show us on next video.

[@lrojas26]

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

[@chilingringa2767]

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

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

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

[@nitinnarkhede1973]

Thank you very much

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