Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel adjust row height upon merging 2 cell with word wrap
When I merge two cells in excel 2003 and format to word wrap, the row height
is not adjusting to show wraped text. I am forced to manually adjust row height |
#2
|
|||
|
|||
That's the way excel works.
Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like: http://groups.google.com/groups?thre...%40tkmsftngp05 If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm RT wrote: When I merge two cells in excel 2003 and format to word wrap, the row height is not adjusting to show wraped text. I am forced to manually adjust row height -- Dave Peterson |
#3
|
|||
|
|||
Merging cells is something that most in here will avoid like the plague.
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "RT" wrote in message ... When I merge two cells in excel 2003 and format to word wrap, the row height is not adjusting to show wraped text. I am forced to manually adjust row height |
#4
|
|||
|
|||
Sorry, meant to add - Format / cells / Centre across selection usually gives
the same visual effect without any of the usual associated hassles. Regards Ken............. "Ken Wright" wrote in message ... Merging cells is something that most in here will avoid like the plague. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "RT" wrote in message ... When I merge two cells in excel 2003 and format to word wrap, the row height is not adjusting to show wraped text. I am forced to manually adjust row height |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste from Word table so that 1 table cell = 1 Excel cell | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How do I make Excel automatically adjust a row's height once I in. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |