Printing a heading on each new page when printing

G

Guest

I'm trying to find out if there is a way of having a heading that I have on
my first page repeated on the top of every page when I print out the
document. At the moment I'm having to inseert the heading at the top of each
page and if I start inserting new columns it means adjusting the page break
each time?
 
N

Niek Otten

File>Page setup>Sheet tab, Rows to repeat at top

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm trying to find out if there is a way of having a heading that I have on
| my first page repeated on the top of every page when I print out the
| document. At the moment I'm having to inseert the heading at the top of each
| page and if I start inserting new columns it means adjusting the page break
| each time?
 

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
Heading on each page 1
Page Breaks- Printing selected rows on same page 1
Repeat Pivot Row on when printing 1
Printing multiple sheets... 1
How do I keep heading so it prints on multiple pages 5
"Space before" Heading on a new page is not there 1
"Header" for table/worksheet 5

Top