Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autofit in Merged Cells?
Is there a way to get merged cells to resize with context (autofit)? I can't
seem to get it in 2003. |
#2
|
|||
|
|||
Hi Mick-
Not sure what you're looking for. The width of a merged cell will be equal to the total width of the columns it spans. The merged cell be widened or narrowed as those column's widths are adjusted. If I've misunderstood, please post back with more detail |:) "Mick" wrote: Is there a way to get merged cells to resize with context (autofit)? I can't seem to get it in 2003. |
#3
|
|||
|
|||
The Height is what I'm most concerned with. I want the text to wrap and the
merged cell to resize in height as needed. It doesn't seem to do that, does merging it make it a fixed size? Thanks Mick "CyberTaz" wrote: Hi Mick- Not sure what you're looking for. The width of a merged cell will be equal to the total width of the columns it spans. The merged cell be widened or narrowed as those column's widths are adjusted. If I've misunderstood, please post back with more detail |:) "Mick" wrote: Is there a way to get merged cells to resize with context (autofit)? I can't seem to get it in 2003. |
#4
|
|||
|
|||
Mick
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 Mon, 14 Feb 2005 07:23:04 -0800, "Mick" wrote: Is there a way to get merged cells to resize with context (autofit)? I can't seem to get it in 2003. |
#5
|
|||
|
|||
Well, bummer. Thank you, Gord.
"Gord Dibben" wrote: Mick 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 Mon, 14 Feb 2005 07:23:04 -0800, "Mick" wrote: Is there a way to get merged cells to resize with context (autofit)? I can't seem to get it in 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting merged cells of differant sizes | Excel Discussion (Misc queries) | |||
Auto fit merged cells | Excel Discussion (Misc queries) | |||
paste info into merged cells | Setting up and Configuration of Excel | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |