Heading on each page

  • Thread starter Thread starter slavenp
  • Start date Start date
S

slavenp

How do I set up that the heading of the colums prints off on each page. I'm
using v.2007. Thanks.
 
Open the Page Layout tab
Look for the Page Setup group (second from left)
Click Print Titles (last item in group)
Fill in the Rows to Repeat ... on the dialog box (eg $1:$2 to repeat the
first two rows on each page)

For more search Help with: <Row to Repeat> as your search term
best wishes
 

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

same heading on each page while printing 1
Problem W Header 6
Problem with printing comment in Excel 2007 6
Print Question? 2
Page break dosen't break 4
how do I change column heading in excel (2007) 5
Printing a heading on each new page when printing 3
Is there a way to have colums wrap on a single page 3

Back
Top