3 Ways to AutoFit all Columns and Rows in Excel

It's a constant struggle in Excel to keep columns and rows at the correct width and height in order to show all the important data in your spreadsheet. This video shows three ways to automatically fit your column widths and row heights to the data in your spreadsheet. One of the methods enables you to keep your hands on your keyboard as you work, helping you be a more efficient and effective Excel user. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here is the practice file for this video: bit.ly/excelautofit #excel #exceltutorials #microsoft365 #microsoftexcel

[@nataliameyer4947]

To me the easiest way to fit the cell will be the double clicking in beteween row/ collums . Thank you for your great tutorials . I watch them ( even when I do not need any refreshers ) that is how much I love them

[@kathleenbabb7023]

Thank you for sharing your knowledge. It is so hard to decided on which one but I could see myself using either the first option (just to be familiar with the process) or the third option (it is easy to follow).

[@SkromnitsaKrasotka]

Thank you so much for sharing every little trick with us, things that might be simple for you and so useful and new for others like myself. I love the idea that your videos are so short, anyone can find 5 mins to keep learning and feel good about it 🙂 I`ll try the 2nd method tomorrow.

[@arifuzzamansumon6865]

Thank you very much. Very very good tutorial. I am from Bangladesh.

[@emeek91]

Awesome. I like the second way the best.😊

[@RFVisionary]

👍🏻 Grate hint! I never saw them anywhere. The best shortcut for me is ALT+HOI resp. ALT+HOA. Really fast! Thx. ☀️

[@sll99]

Thank you so much ❤

[@dgirlsportable3196]

Definitely the second method

[@Dina-uz6ur]

Thank you so much sir... It's really a big help...

[@Sanna99971]

The third one. Thank you.

[@LiiLaGiusta]

I like last one!

[@rms3365]

Thanks so much !

[@salaubiola9746]

Great

[@66sandeep66]

Too good

[@mr.dovahkiin5335]

I’m probably use the third option just because it easier to remember.

[@arjunmalviya9028]

2nd and 3rd are same.
2nd is shortcut with keyboard use and no use of mouse.

[@margievanhandel259]

Finding your tutorials very interesting, but I don't find myself usually needing to work in a spreadsheet. I've been looking for some help on YT and can't seem to locate what I'm looking for. Might you be able to advise please? When I enter a specific cell size, the worksheet doesn't print out with those measurements. Example, if I have 8 rows being 1" each, when I print it doesn't equal 8". I require this precision, and actually need to end up with this file in a photo editing program. I've saved as pdf. Converted to jpg to use as an image. In none of the file formats do I get the row height as needed. But, the width always comes out. I have to be missing something in Excel that this isn't working. Suggestions would be greatly appreciated. Thanks