Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
put large amount of text into merged cell
John
You could be running into either or both of two problems. Merge as many cells as you want, you still have only one cell. 1. A cell will hold 32,767 characters, but will display or print only 1024 characters. More with a few ALT + ENTER's thrown in. 2. Merged cells can be text-wrapped but they will not "Autofit". Manually increase the column width and row height to overcome the second problem. The first can be mitigated somewhat by using smaller font and ALT + ENTER every few hundred characters. Gord Dibben Excel MVP On Tue, 11 May 2004 12:21:06 -0700, "John" wrote: In VBA, I tried to merged 4 cells (C3:D4), then set word wrap up. After that I input large size text into this merged cell (C3). But the cell size was not automatically increased (either way) to fully display the text. Any suggestion, Appreciate ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasteing large amount of text to Excel merged cell | Excel Discussion (Misc queries) | |||
How do I get the a large amount of text to show in merged cell? | Excel Discussion (Misc queries) | |||
how do I import a large amount of text into one cell? | Excel Discussion (Misc queries) | |||
How do I paste a large amount of text into a cell ? | Excel Discussion (Misc queries) | |||
Fit large amount of text in 1 cell | Excel Discussion (Misc queries) |