3 Ways to AutoFit all Columns and Rows in Excel

[nataliameyer]

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

[kathleenbabb]

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

[arifuzzamansumon]

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

[unavailableinyou]

I have liked the third one. Thank you very much for sharing this tutorial.😃

[emeek]

Awesome. I like the second way the best.😊

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

[RFVisionary]

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

[millevenon]

Thanks for explaining well and getting to the point

[Dina-uzur]

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

[tomjackson]

Auto fit row height was the one thing I struggled with, and all of these are great tips. But that is the one that I will use the most. At least I think so; but I will probably use all of them lol😂

[mr.dovahkiin]

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

[margievanhandel]

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

[ruginniu]

Your example does not include certain columns that are huge compared to others how do control margins in that scenario?

[ShrillB]

Do you happen to know of a way one can enable excel to automatically and permanently autofit row heights and column widths?

I have referred my question to Microsoft representatives, stack overflow.
I have been told my inquiry will probably be conducted through macros. I have reached a point where a particular macro does indeed work; however, functions such as the undo function (control + z) does not work.
Unless there is a button in excel I simply have to press to enable this to happen, I have had no luck with my inquiry.

I was told by one person on stack overflow that my inquiry is impossible to complete. Do you happen to know of a way I can complete this?

[ericpeterson]

When I do this is it doesn't save next time I open the document. ANy ideas?