Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
excell - merging cells
How can I merge cells to create one page and have all the text wrap? I have
merged all the cells on one page and created one merge. As I type text some of the text merges, and other text does not - all on the same page. Why? How do I make all the text on each line wrap? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
excell - merging cells
flores
Merging a great block of cells creates one big cell with the limitations of one cell. One of those limitations is the amount of viewable text. You can enter 32767 characters in a cell but only 1024 will be visible or can be printed. If you stick an ALT + ENTER carriage return every 100 characters you can increase this 1024 limit. Otherwise, use a text box or a Word processing program like MS Word. Gord Dibben MS Excel MVP On Thu, 26 Oct 2006 12:53:02 -0700, flores wrote: How can I merge cells to create one page and have all the text wrap? I have merged all the cells on one page and created one merge. As I type text some of the text merges, and other text does not - all on the same page. Why? How do I make all the text on each line wrap? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging cells and keeping their contents | Excel Discussion (Misc queries) | |||
Merging Cells that contain data anomaly | Excel Discussion (Misc queries) | |||
merging the layout only of 2 cells | Excel Worksheet Functions | |||
I cannot select nonadjacent cells in Excell Office XP SP2 | Excel Discussion (Misc queries) | |||
Merging cells with text as one line | Excel Worksheet Functions |