Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make (XL) Merge Cells and Word Wrap work concurrently?
All,
Attempting to check Merge Cells and Word Wrap under Format Cells to create an effective large text cell. They do not seem to work concurrently. Once the cells are merged, word wrap does not work. This is a "want" as I am trying to create a worksheet as data collection/exit report for testing and need the format to be neat. Any thoughts on workarounds? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make (XL) Merge Cells and Word Wrap work concurrently?
George
Merged cells do not hold any more text then any original single cell. Merging 14 cells just creates one larger single cell with single cell limitations. One of those limitations is that the cell can hold 32767 characters but you can view or print only 1024 of those by default. See specifications in Help. One work-around is to insert a carriage return every 100 chars by hitting ALT + ENTER. Wrap Text works with merged cells. However, row height autofit does not work with merged cells. Gord Dibben MS Excel MVP On Tue, 2 May 2006 07:26:03 -0700, George D. <George wrote: All, Attempting to check Merge Cells and Word Wrap under Format Cells to create an effective large text cell. They do not seem to work concurrently. Once the cells are merged, word wrap does not work. This is a "want" as I am trying to create a worksheet as data collection/exit report for testing and need the format to be neat. Any thoughts on workarounds? |
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) | |||
contents in cells are not visible when word wrap is selected | Excel Discussion (Misc queries) | |||
Is there a way to setup word wrap within cells? | Excel Discussion (Misc queries) | |||
Word wrap | Excel Discussion (Misc queries) | |||
Word Wrap in Cells | Excel Discussion (Misc queries) |