View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default Excel row height v. printed page

Try smaller font, or better yet - use a textbox sitting on top of the cell
(or occupying several cells) The text in a textbox will all print.

"Geri Rigger" <Geri wrote in message
...
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.