Autosizing Rows in Excel
Autosizing Rows in Excel
(OP)
How do you get rows in Excel to automatically resize themselves to display all of the text?
Even if I select a row and then pick Format/Row/Autofit it does not always work. "Always" is the key word. Sometimes it works, sometimes not.
Problem seems to exist even with a brand new file.
I'm using Microsoft Office Excel 2003 & have done all updates.
Even if I select a row and then pick Format/Row/Autofit it does not always work. "Always" is the key word. Sometimes it works, sometimes not.
Problem seems to exist even with a brand new file.
I'm using Microsoft Office Excel 2003 & have done all updates.





RE: Autosizing Rows in Excel
RE: Autosizing Rows in Excel
RE: Autosizing Rows in Excel
That's what I've found too. Oh well, just another MicroSoft bug.
RE: Autosizing Rows in Excel
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Autosizing Rows in Excel
RE: Autosizing Rows in Excel
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Autosizing Rows in Excel
RE: Autosizing Rows in Excel
If "Wrap text" is on then the row needs to automatically change its height to display everything typed in that row....or at least that seems like how it should work.
RE: Autosizing Rows in Excel
This may have to do with the difference between the text on the screen and the printed text, they don't always have quite the same size. No fix for that, unless you resize the column width.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Autosizing Rows in Excel
Autofit applies to a specific selection, so if you change something that causes obscuration of the contents, you have to re-run Autofit.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Autosizing Rows in Excel
RE: Autosizing Rows in Excel
I believe it may have some relevance to the type of font being used. It was working fine yesterday using arial font. Then I changed to arial narrow font and the autosize function would no longer size the rows large enough.
It appears to be a bug and hopefully somebody can enlighten all of us that have experienced this on how to avoid triggering the bug or some kind of work around.
RE: Autosizing Rows in Excel
0.01 Autofit doesn't work properly if you have merged cells.
0.02 Depending on the fonts you use, column widths and row heights may appear differently when you print or view a worksheet in print preview. This behavior occurs when you use proportionally spaced fonts, such as a proportional TrueType font. Read http://support.microsoft.com/kb/214394 or google for "excel autofit row height" or something similar.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Autosizing Rows in Excel