Automatic row height adjustment

N

nsv

I have some cells which are to contain a text input. When the text is
longer than the cell the line should split and the cell double its
height automatically.

I have adjusted these settings for one cell and copied them into the
others, but only some of these cells will adjust automatically while
others will not; I have to expand them manually by dragging the bottom
line of the row downwards. To click "Autofit" in the "Format" menu
doesn't work either.

Can anyone tell me how to correct this?

NSV
 
C

CLR

Select the cell with the too-long text, then Right-click > FormatCells >
AlignmentTab > check the WordWrap box

Vaya con Dios,
Chuck, CABGx3
 
N

nsv

Muchas gracias, pero aqui Diós no me ayuda because I just found out,
that merged cells don't autofit...

NSV
 
N

nsv

Now I have 'unmerged' all the cells and set them to wrap text. This
makes it possible to adjust row height by double clicking on the border
to the row below, but the adjustment is still not automatic and double
clicking every single row in a 450 row spread sheet is rather tedious
and risky.

Does anyone know a way, a command or a key sequence that in one single
go makes all cells containing wrapped text adjust their row height so
that all the text is visible?

NSV
 
P

Pete

Have you tried highlighting all the cells then Format | Row | Autofit
now that you have unmerged them ?

Pete
 
Top