how do I get alt-enter to expand word wrap cell

G

GREYL

When I use alt-enter to do multiple lines in a word wrap cell, the cell does
not expand to show all lines in Excel 2002. How can I get around this?
 
D

Dave Peterson

If the rowheight has been set manually, then excel respects that.

You can autofit that rowheight and excel will autofit the rowheight when
required.
 
R

Ragdyer

And one usually resets the autofit by clicking:

<Format> <Row> <AutoFit>.

Which is necessary after every manual adjustment.
 
D

Dave Peterson

One can also double click on the line in the row header (under the row number)
of the row to be autofit, if one wishes.

<vbg>
 
R

RagDyeR

One can be sure of the proper cursor placement for this "double click
autofit", when one sees the cursor change to a double ended arrow.


(had to think of something)<bg>

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

One can also double click on the line in the row header (under the row
number)
of the row to be autofit, if one wishes.

<vbg>
 
D

Dave Peterson

Thank one very much.
One can be sure of the proper cursor placement for this "double click
autofit", when one sees the cursor change to a double ended arrow.

(had to think of something)<bg>

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

One can also double click on the line in the row header (under the row
number)
of the row to be autofit, if one wishes.

<vbg>
Click to expand...
 
Top