| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rows with merged cells are not adjusting even w/ Wrap Text and au.
|
|
#2
|
|||
|
|||
|
Would be more beneficial to all if you included a description of your problem
in the body of the message. The subject line gets truncated after a number of characters. But...... Merged cells will allow "wrap text" from FormatCellsAlignment 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?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 Tue, 4 Jan 2005 11:05:02 -0800, "mkern20" wrote: |
| 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) | |||
| How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
| How do I get merged cells to display all text. | Excel Discussion (Misc queries) | |||
Linear Mode
