print setup -columns to repeat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this is hard to describe, but I am trying to print a wide worksheet
onto two pages and am using the Print Setup - Sheet - Columns to repeat
feature- (column A).
My column A entries has text which vary in size, with entries toward the
bottom being descriptions which overlap columns b, c, d, e, however they are
all contained in column A (cells in b, c, d, e are blank, as are the cells on
page 2 for the columns v, w, x, y, etc for those rows). The first page prints
fine, but the second page cuts off the text. Any ideas on how to correct this?
 
Thu, 19 Jul 2007 13:16:00 -0700 from Kim
I know this is hard to describe, but I am trying to print a wide worksheet
onto two pages and am using the Print Setup - Sheet - Columns to repeat
feature- (column A).
My column A entries has text which vary in size, with entries toward the
bottom being descriptions which overlap columns b, c, d, e, however they are
all contained in column A (cells in b, c, d, e are blank, as are the cells on
page 2 for the columns v, w, x, y, etc for those rows). The first page prints
fine, but the second page cuts off the text. Any ideas on how to correct this?
Click to expand...

Option 1: Widen column A so that it contains all the text.

Option b: Make selected rows higher, and set cell formatting in
column A for those rows to "wrap text".

Option iii: make columns A:E, not just column A, the columns to
repeat.

Of the three, I think option b is cleanest. Even though it's more
work, it will waste the least print space.
 
Yes, we ended up wrapping text. A:E didn't work right for us and widening the
column didn't work, as the text was too long. We also tried setting up the
text at the bottom as a footer, but too long for that too. I think the
wrapping is best too. Thanks for your suggestions.
 
Back
Top