Question Locked

Autofit Row Height Not Working

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anybody know how to fix a cell that will not allow Autofit Row Height to adjust the row height properly (so all text in the cell fits)?

These are NOT merged cells, I can manually adjust row height with no problem, It does NOT occur on all cells, just this particular one. Cell and worksheet are not protected.

Wrap text works fine for column width, just can't get row height any wider than 192 pixels when I need it to go 445 pixels. Carriage returns (Alt+Enter) works, but only one line at a time.

I am using both Excel 2003 and 2007 with Windows XP.

3 replies

by ic-it

is too great. The max height is only suppose to be 409 points; which works out to
72 points to the inch the max is 5.680556 inches.
Try shrinking it to 409 and see if auto works.

This discussion is closed to new replies.