Quickly Resize Multiple Columns and Rows Quickly in Excel

Поділитися
Вставка
  • Опубліковано 23 сер 2024
  • VBA/Macros Course (40% Discount): www.teachexcel...
    Excel Forum: www.teachexcel...
    Visit www.TeachExcel... for more, including Excel Consulting, Macros, and Tutorials.
    This Excel video tutorial shows you how to automatically and quickly resize multiple columns and rows at once in Microsoft Excel. This includes resizing many columns and rows at once as well and automatically resizing an entire worksheet of columns and rows at once. This is a great tutorial for learning how to professionally and quickly format your Excel spreadsheets and worksheets.
    For Excel consulting or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
    Have a great day!

КОМЕНТАРІ • 207

  • @TeachExcel
    @TeachExcel  2 роки тому +3

    VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=youtube_pinned_comment_Yeb8emsjtf4

  • @ExcelAtData
    @ExcelAtData 3 роки тому +75

    Nice Video. There is a keyboard shortcut to resize the columns. Press Ctrl + A to select all the cells then ALT + H + O + I to automatically resizing Column widths. Similarly for Rows, Press Ctrl + A to select all the cells then ALT + H + O + A to automatically resizing Row widths.

    • @tanveersaeed1576
      @tanveersaeed1576 3 роки тому +4

      Zabardast Bhai. Didn't feel the need to even watch the video 🤣. Thanks alot. It worked.

    • @user-zd4ez7tt8i
      @user-zd4ez7tt8i 3 роки тому

      this helped so much thank you !

    • @kurosakiiggy587
      @kurosakiiggy587 2 роки тому

      Hey thankss

    • @sketchinghands4554
      @sketchinghands4554 2 роки тому +1

      Thanks man

    • @Pannakoppala
      @Pannakoppala 2 роки тому

      why do u think its not working for me at all to resize my excel sheet? what could be the reason? pls

  • @kr0nz
    @kr0nz 2 роки тому +1

    who would have thought that after 13 years (this video is 13 years old), your video would have helped a grown ass man try to figure out how to NOT lose his job. lmao AND IT WORKED. thank you!

  • @errffadurff
    @errffadurff 4 роки тому +9

    Just what I was looking for. Simple and right to the point.

  • @michaelkb8-245
    @michaelkb8-245 3 роки тому +1

    Lool I know 12yrs has passed but, this was still so helpful and saved me so much time resizing columns individually. Thanks :)

  • @junnoidunno9229
    @junnoidunno9229 10 місяців тому

    Thank you, learning how to use Excel is fun but learning easy tips and tricks is more fun in satisfying way.

  • @Jdo522
    @Jdo522 8 років тому +1

    Your calm manner makes things so much easier to grasp! Thank you so much!

  • @syedrahman4096
    @syedrahman4096 2 роки тому +1

    Works like a charm, even after 12 years, thanks

  • @Joe_At_Empire_Marketing_Group
    @Joe_At_Empire_Marketing_Group 2 роки тому

    Definitely deserves 5-Stars. Thanks!

  • @laniclemens4627
    @laniclemens4627 3 роки тому +1

    Wish I knew this a long time ago!! Thanks to all experts who share their knowledge here!

  • @andiekpop
    @andiekpop 12 років тому +1

    THANKKYYOUUU!!! i have been resizing columns for over 20 minutes and still have 136 more to do -.- stupid school winter project. ughhh u just saved me so much time!!! thank you!!

  • @katherineh9814
    @katherineh9814 3 роки тому +4

    This is so helpful, concise and clear - thank you!

  • @teenu6782
    @teenu6782 2 місяці тому

    Thank you , saved me bunch of time expanding those

  • @stuchly1
    @stuchly1 6 років тому +2

    Fantastic! I didn't need to use excel for years, so i forgot most of the stuff I knew how to do, thanks for putting these up for people!

  • @mrCetus
    @mrCetus 2 роки тому

    You just saved me lots of time, wish I had found this sooner. Thank you :)

  • @dsgamersyt4808
    @dsgamersyt4808 4 роки тому

    Thank you bud!
    You saved me 3 hours of work!

  • @rotkanon1550
    @rotkanon1550 3 роки тому +2

    got the help I needed from the first minute' thank you so much.

  • @AndreyBassNotes
    @AndreyBassNotes 10 років тому +19

    1:54 Double click or re-size (drag)

    • @zenithxivinvexthal6038
      @zenithxivinvexthal6038 10 років тому +11

      You sir, should be nominated for a Nobel peace prize for the lives you just saved here.

  • @Diosesmipaz3718
    @Diosesmipaz3718 6 років тому +1

    Thank you very much for sharing your knowledge with us. God bless you. It is very, very helpful. 🤗

  • @vesto_se
    @vesto_se 2 роки тому

    The thing you guys are here for starts at 1:52, thanks for the tut bro

  • @iammarcnixon
    @iammarcnixon 3 роки тому +1

    Perfect and straight to the point! Thanks!

  • @user-tk3uy7jl9x
    @user-tk3uy7jl9x 2 роки тому

    This man saved my day... Cheers!

  • @jmanganusa
    @jmanganusa 12 років тому

    Again, cannot believe I have used Excel for years and never know this tricks. Long live Excel-Is-Hell! I owe you a beer.

  • @brendabush5118
    @brendabush5118 Місяць тому

    WONDERFUL tip! thanks!!

  • @aashick9228
    @aashick9228 2 роки тому +1

    Thanks it helped me lot even as software developer ❤

  • @kevinrickey3925
    @kevinrickey3925 4 роки тому

    Thanks, Your presentations are produced well, clear, concise and easy to understand! Well done and excellent!

  • @roadtrips8703
    @roadtrips8703 3 роки тому +1

    Exactly what I needed thank you so much 👍👍👍👍👍

  • @kimbilable
    @kimbilable 9 років тому +4

    That is exactly what I need. Very helpful...Very much appreciated...

  • @KatsPurr
    @KatsPurr 13 років тому +4

    Exactly what I needed, thank you so much!

  • @Archeia
    @Archeia 3 роки тому

    Thank you for the tutorial!

  • @TeachExcel
    @TeachExcel  15 років тому

    No problem. If you need anything else, just let me know.

  • @AalifAli
    @AalifAli Рік тому +1

    Very useful, thanks bro.

  • @JohnnyGarton
    @JohnnyGarton 11 років тому

    Nice tip, video is short and sweet.

  • @19godisgood
    @19godisgood 4 роки тому

    You are heaven sent!

  • @TheSeniorTuberCommunity
    @TheSeniorTuberCommunity Рік тому

    Quick and just what I needed - plus more! thank youQ

  • @K.s.k1
    @K.s.k1 2 роки тому

    So simple - thank you saved me so much time

  • @majedmsx1175
    @majedmsx1175 2 роки тому

    Thanks budd, great explanation

  • @MarielAnne012
    @MarielAnne012 Рік тому

    Cool, thank you!
    Just used for my work rn

  • @happeesoul
    @happeesoul 15 років тому

    Fantastic! You have just saved me a lot of time and frustration! Thank you, thank you, THANK YOU!

  • @souadl3249
    @souadl3249 Рік тому

    Great content!! Was very helpful!! Thank you..

  • @joanl7547
    @joanl7547 2 роки тому

    Thank you. Beautifully done. 😍

  • @growqueen
    @growqueen 3 роки тому

    I know this video is old but thank you.

  • @Purplelace777
    @Purplelace777 6 років тому

    Thank u thanks so much for showing this , I knew it had to be away I could make my rows more space full , thank u thank u

  • @marinahannosh7611
    @marinahannosh7611 3 роки тому

    Thank you so much!!!!!!!!!!!!!!!!!! You are awesome.

  • @angieb8620
    @angieb8620 3 роки тому

    Super simple explanation thanks!

  • @TruthofDilly
    @TruthofDilly 10 років тому

    God bless you! been looking for this for ages! :)

  • @DreDacres
    @DreDacres 11 років тому

    This was a wonderful demonstration, you saved me a lot of time.

  • @deborahmawusiagbeli6547
    @deborahmawusiagbeli6547 4 роки тому

    Was very helpful.Thank you

  • @knowledgefun771
    @knowledgefun771 3 роки тому

    Thanks alot brother you helped me alot

  • @sassypt4310
    @sassypt4310 2 роки тому

    Nice video... it's really helped me a lot
    Thank you 😊

  • @lostaunaum
    @lostaunaum 8 років тому

    You are a hero! Thank you friend!

  • @DANIELSERRANO1885
    @DANIELSERRANO1885 3 роки тому

    Absolutely Amazing!! Thank you for this.

  • @kdum8
    @kdum8 12 років тому

    Thanks. This video did help, although it is slightly different on Excel for mac

  • @tanichea327
    @tanichea327 8 років тому

    Extremely helpful. Many thanks!

  • @realtalkable
    @realtalkable 7 років тому

    Your a lifesaver, Thank you so so much

  • @jamalali8409
    @jamalali8409 6 років тому

    Finally, I found a solution for this matter. Thank you so much1

  • @the_fleeing_dutchman
    @the_fleeing_dutchman 2 роки тому

    Perfect, thank you very much!!

  • @hibernative
    @hibernative 5 років тому +2

    Great tutorial, thanks. STill relevant in 2019. Microsoft programs have gives you optional paralysis :P

  • @Colyers
    @Colyers 7 років тому

    Thanks for the quick tips

  • @AbelKaludzu
    @AbelKaludzu 12 років тому

    Thanks man! This is very HELPFUL!!!

  • @abeselomtadesse8237
    @abeselomtadesse8237 2 роки тому

    Thanks..its very helpful

  • @theanonymous3282
    @theanonymous3282 Рік тому

    OMG!!!!!! THANKS A LOT MAN!!!

  • @jammiemantis
    @jammiemantis 12 років тому

    Thank you very much for this upload. This really helped a lot

  • @user-uc3hh9gr7b
    @user-uc3hh9gr7b 3 роки тому

    Thank you very much.

  • @grid4493
    @grid4493 2 роки тому

    THANKS A LOT BRO !!

  • @1realtruthrightnow742
    @1realtruthrightnow742 Рік тому

    Thank you!

  • @KS-wt8dv
    @KS-wt8dv 7 років тому

    Thank you! Quick and easy!!

  • @journeytolife2215
    @journeytolife2215 2 роки тому

    Thank you it helped me

  • @michaelhoneywill1971
    @michaelhoneywill1971 5 років тому

    Thanks so Much dude. You are the machine manoover man

  • @tabagrisqali
    @tabagrisqali 2 роки тому +1

    Thank you.

  • @dipendramahara7052
    @dipendramahara7052 2 роки тому +1

    Thank you sir.

    • @TeachExcel
      @TeachExcel  2 роки тому

      You're very welcome Dipendra!

  • @Isabelonvideo
    @Isabelonvideo 4 роки тому +1

    Thanks. I save it and when I forward it the receiver sees the # symbols, still. Can u help. ?

    • @HSAcademyOfficial
      @HSAcademyOfficial 4 роки тому

      Well its their headache now :D Different Excel versions probably. Just ask them to use the same trick :)

  • @warrenc.lingcopines4701
    @warrenc.lingcopines4701 5 років тому

    THANK YOU IT WORKS!

  • @corneliuskamran1686
    @corneliuskamran1686 2 роки тому

    Thankyou so much!!!

  • @santoshsalvi2956
    @santoshsalvi2956 3 роки тому

    Exactly, suberp job .👍 Thank you

  • @deyuannawood2649
    @deyuannawood2649 Рік тому

    Thanks so much!!!!

  • @odeyatita8808
    @odeyatita8808 5 років тому

    God bless you Sir

  • @glenn8781
    @glenn8781 4 місяці тому

    Thanks!

  • @sivaprasadjv1574
    @sivaprasadjv1574 5 років тому

    Really helpful. Thanks

  • @leovaldivia4185
    @leovaldivia4185 2 роки тому

    Thank you!!

  • @KishanKishan-fb8dt
    @KishanKishan-fb8dt 4 роки тому

    Thanks man.

  • @areejabdu3125
    @areejabdu3125 10 років тому

    Thanx a Lot ,, that was exactly what i wanted

  • @janegloriahernandez9702
    @janegloriahernandez9702 3 роки тому

    How do you make the cells all one size when they are all different? The first column consist of Header A, B, & C and the other columns have a different number of columns included.

  • @witnessstones
    @witnessstones 13 років тому

    Thanks so much! This was MUCH appreciated!

  • @johnm.evangelis693
    @johnm.evangelis693 6 років тому

    Thank you, l am going to put it to good use!!!

  • @Mohsin07ful
    @Mohsin07ful 8 років тому

    really very helpful
    thanx a lot buddy

  • @Universal260
    @Universal260 4 роки тому

    Thank you Excellent

  • @Katdaddy357
    @Katdaddy357 2 роки тому +1

    Thanks

  • @shivshakti4495
    @shivshakti4495 5 років тому

    Thanks a ton brother

  • @hessnej
    @hessnej 11 років тому

    Great tutorial.

  • @paulrichards9595
    @paulrichards9595 12 років тому

    Brilliant. Thank you so much

  • @zombierage8130
    @zombierage8130 6 років тому

    You saved me, thanks

  • @same4074
    @same4074 2 роки тому

    Thank you

  • @ajwatypingphotocopying8971
    @ajwatypingphotocopying8971 5 років тому

    got a good solution thanks

  • @kurosakiiggy587
    @kurosakiiggy587 2 роки тому

    Thanksss useful and helpful

  • @Tonys_Podium
    @Tonys_Podium 3 роки тому

    Can this be done on the mobile app?

  • @gopichandravenkat2404
    @gopichandravenkat2404 3 роки тому

    Thanks a lot

  • @MohitKumar-iw5io
    @MohitKumar-iw5io 2 роки тому

    Sir please tell me any shortcut of formatting 🙏

  • @JartaMan
    @JartaMan 7 років тому

    Thanks! You are awesome.

  • @manishgoswami3317
    @manishgoswami3317 9 років тому

    Thanks! bro you are great!