How to make Excel's "Auto Fit Row Height" feature actually auto fit the row height?

Posted by DanM on Super User See other posts from Super User or by DanM
Published on 2012-02-14T21:16:14Z Indexed on 2012/06/21 15:18 UTC
Read the original article Hit count: 446

Filed under:
|

For every generation of Excel I can remember (including 2010, which I'm using now), Excel's "Auto Size Row" features sometimes fails to actually auto size a row when the cell contains wrapped text. When it works properly, all the text is revealed and there is no additional space below the last line of text. When it fails, it adds extra space below the text. To make matters worse, what you see is not always what you get, i.e., text that appeared okay on screen gets cut off when it's printed. You also get different sizing depending on whether you are zoomed in/out or at actual size.

Simple test case:

Why is there a one-line gap after the text in cell A1 but in A2?

(I double-checked that I applied Auto Fit Row Height to both rows. Zoom level is 100%.)

Auto Fit fails for the first row, succeeds for the second

Is there any known remedy for this without resorting to manually adjusting the row heights (which is not practical for more than a handful of rows)?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about excel-2010