Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing all text contents of Cell
I have an Excel template with the cell set to 'auto fit row height'.
I am able to enter in as much information as needed. The problem is that when I print or view print preview, not all the information is visible. I read that cells can only contain 255 characters, but about 1000 characters are visible and the remaining is not. Can anyone tell me what the character limitations are or how I can get these cells to printout the entire text? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing all text contents of Cell
Look up excel specification in help, you can overcome the limit by applying
line breaks (alt + enter) on a regular basis -- Regards, Peo Sjoblom wrote in message oups.com... I have an Excel template with the cell set to 'auto fit row height'. I am able to enter in as much information as needed. The problem is that when I print or view print preview, not all the information is visible. I read that cells can only contain 255 characters, but about 1000 characters are visible and the remaining is not. Can anyone tell me what the character limitations are or how I can get these cells to printout the entire text? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing all text contents of Cell
The cell can contain 32,767(not 255) characters but only about 1024 will show or
be printed. See Peo's response for a workaround. Gord Dibben MS Excel MVP On Tue, 19 Jun 2007 19:34:06 -0000, wrote: I have an Excel template with the cell set to 'auto fit row height'. I am able to enter in as much information as needed. The problem is that when I print or view print preview, not all the information is visible. I read that cells can only contain 255 characters, but about 1000 characters are visible and the remaining is not. Can anyone tell me what the character limitations are or how I can get these cells to printout the entire text? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Some (somewhat random) cell contents not printing | Excel Discussion (Misc queries) | |||
Printing cell contents problem | Excel Discussion (Misc queries) | |||
How do I prevent cell contents from printing? | Excel Discussion (Misc queries) | |||
Printing Entire Contents of Cell | Excel Discussion (Misc queries) | |||
Preventing cell contents from printing | Excel Discussion (Misc queries) |