Printing in Excel

N

Neil Conduit

If a single cell contains more than around 1000 characters, they don't all
print (or show on preview). Is there an upper character limit?
 
J

JE McGimpsey

Neil Conduit said:
If a single cell contains more than around 1000 characters, they don't all
print (or show on preview). Is there an upper character limit?
Click to expand...

Yes, only the first 1024 characters will display in a cell or print.
This is described in XL Help ("Specifications")


What Help doesn't tell you is that you can extend this limit if you
include a linefeed (CMD-OPT-RETURN) every 1024 characters (and make sure
the cell is set to wrap text).
 
T

TR

Hold down the command key (marked with an apple and/or a sort of curly
symbol) and the option key while pressing the return key.

A linefeed is, in some ways, a holdover from the old days. To start a
new line on a printer, the computer (used to) send two control
characters: a carriage return (CR, send the printing head back to the
left side of the page) and a linefeed (LF, move the print head to the
next line). Details: http://en.wikipedia.org/wiki/Line_feed

TR
 
Top