Autofitting a row
I have the same problem that the excel file could not set a minimumrow height
as in the past excel version. I'm now using the window XP.
Sorry Jim, I couldn't get what you mean about having a cell off screen on
the row.
"Jim Rech" wrote:
I don't think anything changed in Excel 2003. Row heights should autofit
with wrap text cells if the row has not had its height adjusted manually.
If it has it loses it autofit capability until you use Format, Row, Autofit
to get it back.
I think the only way to set a minimum row height is to have a cell off
screen on the row that needs a height of 30, say out in column IV.
--
Jim Rech
Excel MVP
"No Spam Please" wrote in message
...
| Is it just me, or has something changed with Excel 2003?
|
| If I have a cell with wrap text, shouldn't the row size automatically
| increase if the text exceeds the cell size?
|
| For some reason, my text just gets squished. I know I can go to
| Format-Cells-Autofit, but if I do that, the row could SHRINK if I have too
| little text in the cell.
|
| Here's what I want: I want to increase the height of the cell to a decent
| size (e.g. 30). IF the text exceeds the cell, then I want it to expand.
But
| if it doesn't, I want the cell to remain at 30 - not decrease.
|
| Is there a way to do this? Thank you.
|