Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave B
 
Posts: n/a
Default 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


  #2   Report Post  
Dave B
 
Posts: n/a
Default

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

Dave


"Dave B" wrote in message
...
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



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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" wrote:

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

Dave


"Dave B" wrote in message
...
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



  #4   Report Post  
Dave B
 
Posts: n/a
Default

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

Dave

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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" wrote:

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

Dave


"Dave B" wrote in message
...
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





  #5   Report Post  
Ken Wright
 
Posts: n/a
Default

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
...
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" wrote:

First sentence should have been "When I have word wrap on in a single

cell,
......."
Sorry about that

Dave


"Dave B" wrote in message
...
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







  #6   Report Post  
Dave B
 
Posts: n/a
Default

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

Dave



"Ken Wright" wrote in message
...
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
...
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" wrote:

First sentence should have been "When I have word wrap on in a single

cell,
......."
Sorry about that

Dave


"Dave B" wrote in message
...
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







  #7   Report Post  
Ken Wright
 
Posts: n/a
Default

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

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


"Dave B" wrote in message
...
Yeah, but what's life without an occasional merge??? :<)

Dave



"Ken Wright" wrote in message
...
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
...
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" wrote:

First sentence should have been "When I have word wrap on in a single

cell,
......."
Sorry about that

Dave


"Dave B" wrote in message
...
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









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Different graphic for each record in mail merge document Alex St-Pierre Charts and Charting in Excel 1 May 4th 05 07:26 PM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 04:37 PM
How do I do an excel merge like a word mailmerge with another exc. jaewon223 Excel Discussion (Misc queries) 0 February 28th 05 06:01 PM
Mail Merge Question FNORD Excel Discussion (Misc queries) 3 February 9th 05 08:18 PM
Serious Mail Merge Problem FNORD Excel Discussion (Misc queries) 0 February 8th 05 06:13 PM


All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"