Maximum Cell Size

D

Donna Stearns

I have a memo cell where I have invoked wordwrap. Eight
lines of landscape text print and the balance of the text
is cut off even though the cell appears to have more
space. Is there a maximum size that a cell can be? How
can I get the cell to print all of the text in the cell?
 
G

Gord Dibben

Donna

Excel allows 32,767 characters in a cell but will show or print only 1024(see
Help>Specifications).

One workaround is to spread a few ALT + ENTER's at spots. This will increase
the amount shown. Don't know how far this will go.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell data entering slow! 0
How can the font and size of (all) citation numbers be altered? 1
Printing Outline view - formatting lost 0
Place picture in Excel cell 0
How to paste this down? 3
Maximum Text in Cells for Printing 1
Space at end of multi page list to accommodate new entries 1

Top