How do I get my column titles to print at the top of 2nd page?

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

Guest

I want to repeat Row 3, Columns A-G at the top of each page when it prints.
How is that done?
 
In File | Page Setup select the Sheet tab and you will see a box Rows
to Repeat at Top - just enter your row(s) here. Ensure that you exclude
them from the print range, otherwise they will appear twice on the
first page.

Hope this helps.

Pete
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Repeat Row at Top of Worksheet 2
Print Column Heads WITHOUT Excel Column Lables 1
How do I repeat rows at the top of SOME of the pages in Excel 2
Can I repeat rows at the top, except the last page? 3
Print Titles 3
Title HELP!!! 1
Printing non-contiguous rows at the top 1

Back
Top