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

[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?

[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.

GREYL wrote:
>
> 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?

--

Dave Peterson

[Ragdyer]

And one usually resets the autofit by clicking:

<Format> <Row> <AutoFit>.

Which is necessary after every manual adjustment.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> If the rowheight has been set manually, then excel respects that.
>
> You can autofit that rowheight and excel will autofit the rowheight when
> required.
>
> GREYL wrote:
> >
> > 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?
>
> --
>
> Dave Peterson

[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>

Ragdyer wrote:
>
> And one usually resets the autofit by clicking:
>
> <Format> <Row> <AutoFit>.
>
> Which is necessary after every manual adjustment.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > If the rowheight has been set manually, then excel respects that.
> >
> > You can autofit that rowheight and excel will autofit the rowheight when
> > required.
> >
> > GREYL wrote:
> > >
> > > 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?
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

[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 !
----------------------------------------------------------------------------
-------------------

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
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>

Ragdyer wrote:
>
> And one usually resets the autofit by clicking:
>
> <Format> <Row> <AutoFit>.
>
> Which is necessary after every manual adjustment.
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > If the rowheight has been set manually, then excel respects that.
> >
> > You can autofit that rowheight and excel will autofit the rowheight when
> > required.
> >
> > GREYL wrote:
> > >
> > > 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?
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

[Dave Peterson]

Thank one very much.

RagDyeR wrote:
>
> 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 !
> ----------------------------------------------------------------------------
> -------------------
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> 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>
>
> Ragdyer wrote:
> >
> > And one usually resets the autofit by clicking:
> >
> > <Format> <Row> <AutoFit>.
> >
> > Which is necessary after every manual adjustment.
> > --
> > HTH,
> >
> > RD
> >
> > --------------------------------------------------------------------------
> -
> > Please keep all correspondence within the NewsGroup, so all may benefit !
> > --------------------------------------------------------------------------
> -
> > "Dave Peterson" <[email protected]> wrote in message
> > news:[email protected]...
> > > If the rowheight has been set manually, then excel respects that.
> > >
> > > You can autofit that rowheight and excel will autofit the rowheight when
> > > required.
> > >
> > > GREYL wrote:
> > > >
> > > > 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?
> > >
> > > --
> > >
> > > Dave Peterson
>
> --
>
> Dave Peterson

--

Dave Peterson