How do I keep heading so it prints on multiple pages

G

Guest

I want to print multiple pages using the same heading that is at the
beginning of a column without having to insert rows with the same heading at
a page break.
 
P

Pete_UK

Go to File | Page Setup | Sheet tab and you will see that you can
specify Rows to Repeat at Top. Ensure that your print area excludes
these rows, otherwise they will be printed twice on the first page.

Hope this helps.

Pete
 
G

Guest

File, Page Setup and click on the Sheet tab. Click in the box 'Rows to repeat
at top' and select your row(s) on the worksheet.
 
G

Gord Dibben

File>Page Setup>Sheet>"Rows to repeat at top"

Enter 1:1 or point to the row(s) you want repeated.


Gord Dibben MS Excel MVP
 
G

Guest

Hi Pete,

Why the print area should exclude the rows to repeat at top? It will not be
printed twice even if it is included.

Jaleel
 
G

Guest

Go to File select "Page setup" select the "Sheet" tab and then click the "row
to repeat at top" text box and then select your heading row, and click on
text box againg and then click print.
 

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

Firefox Multi-Account Containers 1
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
how can i print (row) titles on all pages except the last page? 3
same heading on each page while printing 1
Page Breaks- Printing selected rows on same page 1
Heading on each page 1
Dates as text 7
Printing a heading on each new page when printing 3

Top