Comments | admin_prof: Excel 2007 Autofit Row Height

traceroo in admin_prof

Excel 2007 Autofit Row Height

Dec 02, 2010 11:05

I realize that I'm probably the last one to know this, and this is old news to all of you! ;) The formerly simply process of getting Excel to autofit the Row Height in Excel 2007 just brought my productivity, and that of the CEO's executive assistant who helped me, to a crashing halt for 10 minutes! Argh! Here's how you do it in Excel 2007, for the ( Read more... )

excel 2007, excel

Comments 5

brave_margot December 2 2010, 20:53:36 UTC

Oh I hate it when that kind of thing happens! But how sweet it is when it gets figured out!

loopygoat December 3 2010, 04:10:03 UTC

You can also auto fit both rows and columns by double clicking the line between rows/columns on the Headings (A, B, C, 1, 2, 3, etc) when the cursor turns into a double arrow. You can select more than one row/column and double click and all of them will auto fit. A lot of times, I select all and then double click so the whole spreadsheet is formatted with autofit.

This video shows in it case I didn't explain very well :)

Good fix! traceroo December 3 2010, 16:16:52 UTC

In this case, I have a spreadsheet with a million rows (give or take!), so I really wanted to hunt down the "short" solution to the problem. Little did I know that this would not be brief. ;)

Trace

mutu26 January 14 2011, 05:14:11 UTC

I often work with ms excel data and one day I had an unpleasant problem with excel documents which I successfully work out with the aid of an utility. It might relieve in like situation - How to recover Excel files.

I can't find anything!! traceroo January 18 2011, 17:24:03 UTC

I'm so glad I posted this here since I already forgot where to find it, and just had to look up my own notes on it! UGH!

Trace