Re: Automatically change row height when wrapping text in merged cell.
From: Gord Dibben (gorddibbATshawDOTca)
Date: 10/19/04
- Next message: Myrna Larson: "Re: Copying Column Data and Pasting it into a Row"
- Previous message: Gord Dibben: "Re: When opening Excel it ask for Microsoft Office 2000 SR-1 Premium ."
- In reply to: wadrazil: "Automatically change row height when wrapping text in merged cell."
- Next in thread: wadrazil: "RE: Automatically change row height when wrapping text in merged cell."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 15:46:57 -0700
wad
Merged cells will allow "wrap text" from Format>Cells>Alignment but..........
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?threadm=e1%241uzL1BHA.1784%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 Tue, 19 Oct 2004 15:19:06 -0700, "wadrazil"
<wadrazil@discussions.microsoft.com> wrote:
>How do I get Excel to change the row height to change automatically when
>wrapping text in merged cells. The autoheight feature works just fine in
>unmerged cells.
- Next message: Myrna Larson: "Re: Copying Column Data and Pasting it into a Row"
- Previous message: Gord Dibben: "Re: When opening Excel it ask for Microsoft Office 2000 SR-1 Premium ."
- In reply to: wadrazil: "Automatically change row height when wrapping text in merged cell."
- Next in thread: wadrazil: "RE: Automatically change row height when wrapping text in merged cell."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
