How to print each row on a separate page?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

phuile@yahoo.ca - 17 Jun 2006 09:08 GMT

Is there a way to print a worksheet one or two rows to a page?

For example, I have a worksheet with 300 rows, and I want to print:
- row 1 and 2 on page 1
- row 1 and 3 on page 2
- row 1 and 4 on page 3 etc.
(i.e. row 1 is always printed, but on each page it is printed with a
different row).

Is there a way to do this *automatically*, since I have about 300-400
rows to print this way?

Thanks for any help!
Petre

Reply to this Message

David McRitchie - 18 Jun 2006 14:23 GMT

Hi Petre,
One way would be to use excessive bottom margin so that you
can only print two rows.

A better way would probably be, just before printing
1) Select Column A
2) Insert (menu), page break
3) select Row 1, Insert (menu), Remove page break

To make sure you are printing the heading row on each page
File, Page Setup, Sheets, Rows to repeat at top: $1:$1

To see top row within Excel you would use freeze panes, both
freeze panes, and repeat rows & columns are explained in detail in
http://www.mvps.org/dmcritchie/excel/excel.htm

After printing:
Select all cell, Insert, Remove page break

You can record a macro to do all of the above, including the actual printing.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Is there a way to print a worksheet one or two rows to a page?
>
[quoted text clipped - 10 lines]
> Thanks for any help!
> Petre

Reply to this Message

phuile@yahoo.ca - 19 Jun 2006 07:19 GMT

Thanks ... I discovered a further problem - I know about setting the
page always to print the first row. However, my problem is now the
length of the row. There are 107 columns and about 210 rows on my
spreadsheet. What I need to do is to do as I mentioned earlier (i.e.
print row 1 & 2, 1 & 3 etc).

Since the row is very long, the print preview shows 2 rows on a
letter-size page but on 6 pages. I'd like to know if there is a way to
print the 2 rows but on 1 page.

Thanks, Petre

> Hi Petre,
> One way would be to use excessive bottom margin so that you
[quoted text clipped - 36 lines]
> > Thanks for any help!
> > Petre

Reply to this Message

phuile@yahoo.ca - 19 Jun 2006 07:23 GMT

Hi David, Forgot the ask in my last reply - I tried your "better way"
but when I select column A, the Page Break item is greyed out. It is
the same way when I select Row 1.

Can you clarify?

Petre

> Hi Petre,
> One way would be to use excessive bottom margin so that you
[quoted text clipped - 36 lines]
> > Thanks for any help!
> > Petre

Reply to this Message

David McRitchie - 19 Jun 2006 17:16 GMT

Hi Petre,
Sorry, I guess you can't insert page breaks for more than one cell,
or one row, or one column at a time. Copying the formats with
the format painter tool will not copy the inserted page breaks, either.

So you would need a macro, and the macro would also snake the
columns. But you have another problem with that because you have
a header row,

Print all of the header row, then all of the detail row.
or print header row segment, detail segment;
head row segment, detail segment, empty row, ...,
header row segment, detail segment.

The other problem alignment of cell borders must be the same
for the entire new page. You can't have different widths for
cells underneath each other.

If the width of the cells is not a problem then you can modify
a macro in the snakecol.htm page (and code/snakecol.txt) page;
http://www.mvps.org/dmcritchie/excel/snakecol.htm
http://www.mvps.org/dmcritchie/excel/code/snakecol.txt

otherwise, if that is not acceptable you might use Mail Merge
to print from MS Word with Excel as your database.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Hi David, Forgot the ask in my last reply - I tried your "better way"
> but when I select column A, the Page Break item is greyed out. It is
[quoted text clipped - 44 lines]
> > > Thanks for any help!
> > > Petre

Reply to this Message

Rate this thread: