A cell can hold 32767 characters but will show or print only 1024 of these
characters in a cell.

If you add a linefeed.....Alt + Enter.........every 100 or so characters you
can increase this limit considerably.


Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 11:05:02 -0800, Geri Rigger <Geri
wrote:

I have to use Excel to manage project updates with lots of text. Each row is
set to the maximum 409 height, even though you can fit more test in there, it
just won't print. The page when printed has blank space at the bottom, which
would indicate more text could fit on the page, if it wasn't cut off at the
end of each row. My boss doesn't want to simply center the text, but wants
to "fill" the page so as to keep more common data together, without having
pages with only a few lines of data on it.

Is there a way to force an extra 3 or 4 lines (which are in the cell, beyond
the 409 row height) to show in print preview and print on the page. The page
has room for it, I just can't get Excel to do it without putting the extra in
a new row, which then creates a new page. Arghhh!

Thanks for any suggestions.