Row Height with merge - Question

When I have merge on in a single cell, clicking on the lower limit of the
row will enlarge the row to show all text. However, when I also have a
couple of cells merged, this does not work. In fact it collapses the entire
text to a single line.

Is there a way to show all text when both merge and wrap are in effect,
other than by dragging the lower edge?
Thx much

Dave

First sentence should have been "When I have word wrap on in a single cell,
........"
Sorry about that

Dave


"Dave B" <[email protected]> wrote in message
news:[email protected]...
> When I have merge on in a single cell, clicking on the lower limit of the
> row will enlarge the row to show all text. However, when I also have a
> couple of cells merged, this does not work. In fact it collapses the
> entire text to a single line.
>
> Is there a way to show all text when both merge and wrap are in effect,
> other than by dragging the lower edge?
> Thx much
>
> Dave
>

Dave

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?thre...%40tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.


Gord Dibben Excel MVP

On Fri, 4 Mar 2005 05:28:43 -0600, "Dave B" <[email protected]> wrote:

>First sentence should have been "When I have word wrap on in a single cell,
>......."
>Sorry about that
>
>Dave
>
>
>"Dave B" <[email protected]> wrote in message
>news:[email protected]...
>> When I have merge on in a single cell, clicking on the lower limit of the
>> row will enlarge the row to show all text. However, when I also have a
>> couple of cells merged, this does not work. In fact it collapses the
>> entire text to a single line.
>>
>> Is there a way to show all text when both merge and wrap are in effect,
>> other than by dragging the lower edge?
>> Thx much
>>
>> Dave
>>
>

Thanks Gord,
Guess we'll do what we have to do -
Appreciate the help

Dave

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> Dave
>
> Excel has a problem auto-fitting merged cells.
>
> You can resize manually or via Macro. Jim Rech has written
> code for this.
>
> http://groups.google.com/groups?thre...%40tkmsftngp05
>
> Note also a recent adaptation of this code by Greg Wilson.
>
> http://makeashorterlink.com/?P37D24B15
>
> The best cure is DON"T USE MERGED CELLS. They cause no end of problems
> with
> copying, pasting, sorting, filtering.
>
>
> Gord Dibben Excel MVP
>
> On Fri, 4 Mar 2005 05:28:43 -0600, "Dave B" <[email protected]> wrote:
>
>>First sentence should have been "When I have word wrap on in a single
>>cell,
>>......."
>>Sorry about that
>>
>>Dave
>>
>>
>>"Dave B" <[email protected]> wrote in message
>>news:[email protected]...
>>> When I have merge on in a single cell, clicking on the lower limit of
>>> the
>>> row will enlarge the row to show all text. However, when I also have a
>>> couple of cells merged, this does not work. In fact it collapses the
>>> entire text to a single line.
>>>
>>> Is there a way to show all text when both merge and wrap are in effect,
>>> other than by dragging the lower edge?
>>> Thx much
>>>
>>> Dave
>>>
>>
>

Personally I'd say Dave's problem is that he merged cells at all, but that's
just me <g>

merged cells = spawn of devil

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> Dave
>
> Excel has a problem auto-fitting merged cells.
>
> You can resize manually or via Macro. Jim Rech has written
> code for this.
>
> http://groups.google.com/groups?thre...%40tkmsftngp05
>
> Note also a recent adaptation of this code by Greg Wilson.
>
> http://makeashorterlink.com/?P37D24B15
>
> The best cure is DON"T USE MERGED CELLS. They cause no end of problems
with
> copying, pasting, sorting, filtering.
>
>
> Gord Dibben Excel MVP
>
> On Fri, 4 Mar 2005 05:28:43 -0600, "Dave B" <[email protected]> wrote:
>
> >First sentence should have been "When I have word wrap on in a single
cell,
> >......."
> >Sorry about that
> >
> >Dave
> >
> >
> >"Dave B" <[email protected]> wrote in message
> >news:[email protected]...
> >> When I have merge on in a single cell, clicking on the lower limit of
the
> >> row will enlarge the row to show all text. However, when I also have a
> >> couple of cells merged, this does not work. In fact it collapses the
> >> entire text to a single line.
> >>
> >> Is there a way to show all text when both merge and wrap are in effect,
> >> other than by dragging the lower edge?
> >> Thx much
> >>
> >> Dave
> >>
> >
>

Yeah, but what's life without an occasional merge??? :<)

Dave



"Ken Wright" <[email protected]> wrote in message
news:%[email protected]...
> Personally I'd say Dave's problem is that he merged cells at all, but
> that's
> just me <g>
>
> merged cells = spawn of devil
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:[email protected]...
>> Dave
>>
>> Excel has a problem auto-fitting merged cells.
>>
>> You can resize manually or via Macro. Jim Rech has written
>> code for this.
>>
>> http://groups.google.com/groups?thre...%40tkmsftngp05
>>
>> Note also a recent adaptation of this code by Greg Wilson.
>>
>> http://makeashorterlink.com/?P37D24B15
>>
>> The best cure is DON"T USE MERGED CELLS. They cause no end of problems
> with
>> copying, pasting, sorting, filtering.
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Fri, 4 Mar 2005 05:28:43 -0600, "Dave B" <[email protected]> wrote:
>>
>> >First sentence should have been "When I have word wrap on in a single
> cell,
>> >......."
>> >Sorry about that
>> >
>> >Dave
>> >
>> >
>> >"Dave B" <[email protected]> wrote in message
>> >news:[email protected]...
>> >> When I have merge on in a single cell, clicking on the lower limit of
> the
>> >> row will enlarge the row to show all text. However, when I also have
>> >> a
>> >> couple of cells merged, this does not work. In fact it collapses the
>> >> entire text to a single line.
>> >>
>> >> Is there a way to show all text when both merge and wrap are in
>> >> effect,
>> >> other than by dragging the lower edge?
>> >> Thx much
>> >>
>> >> Dave
>> >>
>> >
>>
>
>

hmmmm - I could be reconsidering my position on this one <g>

--
Regards
Ken.......................


"Dave B" <[email protected]> wrote in message
news:%[email protected]...
> Yeah, but what's life without an occasional merge??? :<)
>
> Dave
>
>
>
> "Ken Wright" <[email protected]> wrote in message
> news:%[email protected]...
> > Personally I'd say Dave's problem is that he merged cells at all, but
> > that's
> > just me <g>
> >
> > merged cells = spawn of devil
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
>
> --------------------------------------------------------------------------
--
> > It's easier to beg forgiveness than ask permission :-)
>
> --------------------------------------------------------------------------
--
> >
> > "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> > news:[email protected]...
> >> Dave
> >>
> >> Excel has a problem auto-fitting merged cells.
> >>
> >> You can resize manually or via Macro. Jim Rech has written
> >> code for this.
> >>
> >>
http://groups.google.com/groups?thre...%40tkmsftngp05
> >>
> >> Note also a recent adaptation of this code by Greg Wilson.
> >>
> >> http://makeashorterlink.com/?P37D24B15
> >>
> >> The best cure is DON"T USE MERGED CELLS. They cause no end of problems
> > with
> >> copying, pasting, sorting, filtering.
> >>
> >>
> >> Gord Dibben Excel MVP
> >>
> >> On Fri, 4 Mar 2005 05:28:43 -0600, "Dave B" <[email protected]> wrote:
> >>
> >> >First sentence should have been "When I have word wrap on in a single
> > cell,
> >> >......."
> >> >Sorry about that
> >> >
> >> >Dave
> >> >
> >> >
> >> >"Dave B" <[email protected]> wrote in message
> >> >news:[email protected]...
> >> >> When I have merge on in a single cell, clicking on the lower limit
of
> > the
> >> >> row will enlarge the row to show all text. However, when I also
have
> >> >> a
> >> >> couple of cells merged, this does not work. In fact it collapses
the
> >> >> entire text to a single line.
> >> >>
> >> >> Is there a way to show all text when both merge and wrap are in
> >> >> effect,
> >> >> other than by dragging the lower edge?
> >> >> Thx much
> >> >>
> >> >> Dave
> >> >>
> >> >
> >>
> >
> >
>
>