I have the same problem that the excel file could not set a minimum row
height as in the past excel version.

I don't know what problem you're referring to here. I have several versions
of Excel installed so if you can give me a simple step-by-step example to
see the difference in various Excel versions that might help me.

I couldn't get what you mean about having a cell off screen on | the row.

Nothing particularly brilliant. Let's say that you want an autofit of row 5
never to go below a height of 30. And let's say that you never get way out
to the right side of the sheet so it doesn't matter that you have some junk
in cell IV5. So you select that cell and turn on Wrap Text and type
sufficient text so that the row expands to a height of 30. So a subsequent
autofit would never reduce row height below that, but if greater height were
needed by another cell, autofit would expand it.

--
Jim Rech
Excel MVP
"Josephine" wrote in message
...
|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.
|
|
|