Julie

Your "is now" example shows one row with 13 12's........I think!

Your "want to be" example shows one row with 15 12's in 5 cells or is it 3 rows
of 5 columns each?

How long are the rows?

From A1 to which column?

From A2 to which column?

How many columns do you want when ready to print?

Maybe you should give us some ranges instead of 12's which get line-wrapped in
these posts.

Like A1:AA1 and A2:AA2 or similar.


Gord Dibben MS Excel MVP

On Fri, 7 Mar 2008 15:18:01 -0800, julie
wrote:

hello, i have looked all over the help button for this answer. cant find.
does anyone
know how to print 2 consectutive long rows of information on 1 piece of paper.
It is on 1 excel sheet. i would like it to look like you were reading a book.

example: row 1 12 12 12 12 12 12 12 12 12 12
12 12 12

row 1 12 12 12 12 12
12 12 12 12 12
12 12 12 12 12

--
julie