Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Full cell not printing
I have a cell with 1370 characters. It shows all the text in the formula
bar, but when I print preview or print, only the first 1060 (I think) characters are shown. Is this a known limitation, and is there any way around it? Thanks in advance Daniel |
#2
|
|||
|
|||
Hi Daniel,
The Excel help somewhere states a maximum of 32,767 characters per cell but only 1,024 'visible'. Solution perhaps: split your story over multiple cells by using Left, Mid and Right functions. Frans "Daniel Bonallack" wrote in message ... I have a cell with 1370 characters. It shows all the text in the formula bar, but when I print preview or print, only the first 1060 (I think) characters are shown. Is this a known limitation, and is there any way around it? Thanks in advance Daniel |
#3
|
|||
|
|||
Excel only puts about 1000 characters on one line. Use ALT + Enter to
create line breaks as you type and make sure the cell is formatted to allow multiple lines. Bill "Daniel Bonallack" wrote in message ... I have a cell with 1370 characters. It shows all the text in the formula bar, but when I print preview or print, only the first 1060 (I think) characters are shown. Is this a known limitation, and is there any way around it? Thanks in advance Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
Text in cell not showing in full | Excel Discussion (Misc queries) | |||
Preventing cell contents from printing | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) |