ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Heading on each page (https://www.excelbanter.com/excel-discussion-misc-queries/167824-heading-each-page.html)

slavenp

Heading on each page
 
How do I set up that the heading of the colums prints off on each page. I'm
using v.2007. Thanks.

Bernard Liengme

Heading on each page
 
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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"slavenp" wrote in message
...
How do I set up that the heading of the colums prints off on each page.
I'm
using v.2007. Thanks.





All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com