Printing in Excel

  • Thread starter Thread starter Abdul Salam
  • Start date Start date
A

Abdul Salam

IN EXCEL 2002 I HAVE TO PRIINT FIRST THREE RAWS IN EACH
PAGES AS HEADER, I HAVE MORE THAN 10 PAGES. HOW CAN I
PRINT THESE FIRST THREE RAWS IN EACH PAGES?
 
Abdul Salam, if I understand your question, you have an Excel 2002 worksheet
that, when printed, extends to more than 10 pages. You want Rows 1-3 of the
worksheet to be repeated at the top of each of the 10 pages. Is this so?

If it is so, here is how to do it. From the worksheet:

1-File > Page Setup > Sheet.
2-In the Rows to repeat at top: field, type $1:$3
3-Click OK.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing 1
Access Sorting and grouping using multiple tables 0
Header Insanity 2
printing a header in Excel 2
Printing multiple sheets... 1
How can I set some cells to not print w/o changing print layout? 1
Printing 1
Row 1 HEADERS on EVERY printed page 2

Back
Top