Quickly Resize Multiple Columns and Rows Quickly in Excel

Поделиться
HTML-код
  • Опубликовано: 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!