| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can word wrap and merged cells auto row height properly in Excel
The merged cells do not auto row height properly and therefore do do word
wrap. If you manually size the row, it will word wrap properly. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can word wrap and merged cells auto row height properly in Excel
You have to adjust that manually (or via a macro).
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 wchernock wrote: The merged cells do not auto row height properly and therefore do do word wrap. If you manually size the row, it will word wrap properly. -- Dave Peterson |
| 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 to make (XL) Merge Cells and Word Wrap work concurrently? | Excel Discussion (Misc queries) | |||
| Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
| Autofit row height in merged cells | Excel Discussion (Misc queries) | |||
| How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions | |||
Linear Mode
