Automatic resizing of cell

J

Jessica

I use Excel for my job. When I enter a long text sentence
into a cell that is larger than the cell, it gets covered
up because the text wrapping is on. I want the sentence to
wrap around to the next line, but Excel doesn't
automatically adjust the size of the cell when it sees
that the text is longer. I end up printing out my work and
only half of the sentence is there. I can resize it
myself, but I want Excel to resize it when it sees that
it's covering it. I can't see why anyone would actually
WANT Excel to cover it up.
 
S

Stan Scott

Which version of Excel are you using. I'm using 2002, and Excel DOES resize
the row when the text wraps.

Stan
 
G

Gord Dibben

Jessica

Set the row for "Autofit" and the cell to "wrap text" and you should have no
problems, if..........

The cell(s) is not "merged". Autofit doesn't work with merged cells.

The number of characters in the cell does not exceed 1024 which is the default
number that will show or print.

Gord Dibben Excel MVP
 
Top