How to AutoFit Rows and Columns in Excel | #AutoFit in #Excel
Channel: Stone Barnard
Date: 2021-02-19

#AutoFit Rows and Columns in #Excel effortlessly by using the following 2 methods:

1:19 Method 1: Quick Access Toolbar in excel

2:57 Method 2: Using VBA and Macros in excel

Click the link to get the cheat sheets for the macro method: https://drive.google.com/drive/folders/1sj66YY1Kb4zcUVtu4QLXqHTMfb-JZmBE?usp=sharing

Subscribe for more excel awesomeness by following the link:
https://www.youtube.com/channel/UC1up​​​...

Please follow the link for the resources mentioned in this video:
https://drive.google.com/drive/folder​​​...

Please check out my previous episodes to gain some excel knowledge:

Episode 1   | User form in excel VBA   | https://youtu.be/F1fcGQJKASQ​​​
Episode 2   | Picture lookup in excel    | https://youtu.be/eESammr1Gzk​​​
Episode 3   | Log in function in excel   | https://youtu.be/X1aBnwpBQLw​​​
Episode 4   | Waterfall chart in excel   | https://youtu.be/h44xyF2wnIE​​​
Episode 5   | Combo Boxes in excel     | https://youtu.be/Ie5UU0IOgkw​​​
Episode 6   | Vlookup Speed Run          | https://youtu.be/qj7yKalJCo4​​​
Episode 7   | Index in VBA and excel    | https://youtu.be/YpmEWprV4z4​​​
Episode 8   | Pivot table in excel VBA   | https://youtu.be/4CIRg8eU1wk​​​
Episode 9   | Loan calculator in excel   | https://youtu.be/TjuuVkCMyr8​​​
Episode 10 | 100 Subscriber episode   | https://youtu.be/izsvfZEYbV8​​​
Episode 11 | Vlookup in excel & VBA   | https://youtu.be/6s1zxRS27K0​​​
Episode 12 | Investment calculator      | https://youtu.be/-OFUankN9nk​​​
Episode 13 | Pipe charts in excel          | https://youtu.be/NB5EGBr3GRA​​​
Episode 14 | Auto Candlestick graphs | https://youtu.be/5s0BR55oYAk​​​
Episode 15 | Bullet charts in excel        | https://youtu.be/d09aeUbi7mA​​​
Episode 16 | Record Macro in Excel     | https://youtu.be/5uiYOhc4GO8​​​
Episode 17 | Pop-up Calendar in Excel | https://youtu.be/jC_WkOY32eY​​​
Episode 18 | 5 Top Table Tips in Excel | https://youtu.be/2NMWfjgVgoc​​​
Episode 19 | Excel game for free           | https://youtu.be/BOnFXYNhrtY​​​
Episode 20 | Excel is fun with colors    | https://youtu.be/_mY1neoj0D0​​​
Episode 21 | Combo Pie Chart in excel | https://youtu.be/CoOuK9uwRSk​​​
Episode 22 | 3D Maps in Excel               | https://youtu.be/vhnctPgFmT4​​​
Episode 23 | Camera in Excel                 | https://youtu.be/4drwwhiPhaQ​​​
Episode 24 | Add / delete pdf in excel  | https://youtu.be/9sj0LMPFHSA​​​
Episode 25 | Customize desktop icons | https://youtu.be/YxG--tk4dT4​​​
Episode 26 | Pivot table & Timeline       | https://youtu.be/7l9o4Y4nZ70​​​
Episode 27 | Pivot table & Timeline       | https://youtu.be/7l9o4Y4nZ70​​​
Episode 28 | How to Prevent duplicates | https://youtu.be/loNROteUyfE​​​
Episode 29 | Timed macros in excel      | https://youtu.be/tZux0TGwObM​​​​
Episode 30 | Copy and paste shortcuts | https://youtu.be/y6oDJiyehx0​
Episode 31 | How to combine in excel   | https://youtu.be/9Qb2GRxWy9o

Check out my Facebook page and share my content by following the link: https://www.facebook.com/stone.barnard​​​

Please comment below if you have an idea for a tutorial or would like to reach out!

Buckle-up and let's Excelerate!