Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merged Cell Row Height
I have separate worksheets in one file and descriptions typed in separate
rows in one column on the main one. These descriptions replicate to other (merged) columns in other worksheets but the lines do not automatically change to suit the height of the text. I have searched through the discussion group but only found replies to do with macros. I do not have a clue how to use it. I could maybe email somebody an example of what I mean if that wasn't clear enough. Can anybody help me please? Jonny |
#2
|
|||
|
|||
Jonny
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 Also revised code for special cases. http://snipurl.com/dfsm 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, 21 Mar 2005 05:09:03 -0800, "Jonny" wrote: I have separate worksheets in one file and descriptions typed in separate rows in one column on the main one. These descriptions replicate to other (merged) columns in other worksheets but the lines do not automatically change to suit the height of the text. I have searched through the discussion group but only found replies to do with macros. I do not have a clue how to use it. I could maybe email somebody an example of what I mean if that wasn't clear enough. Can anybody help me please? Jonny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
Autofit row height in merged cells | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions |