Printing in Excel

[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?

 

[JE McGimpsey]

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?

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).

 

[Neil Conduit]

OK Thanks very much for that...what is a linefeed and how do I do it?

 

[JE McGimpsey]

OK Thanks very much for that...what is a linefeed and how do I do it?

re-read my reply...

 

[Neil Conduit]

Sorry, I have no idea what CMD-OPT-RETURN means

re-read my reply...

 

[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