Print top rows on each page

User avatar
VegasNath
5StarLounger
Posts: 1185
Joined: 24 Jan 2010, 12:02
Location: Wales, UK.

Print top rows on each page

Post by VegasNath »

I have a document that prints rows 2&3 at the top of each page. The first page prints rows 1, 2 & 3 as expected, but row 1 does not print on subsequent sheets. I have no idea how this was set up, where do I need to look to correct this?
:wales: Nathan :uk:
There's no place like home.....

User avatar
HansV
Administrator
Posts: 78626
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Print top rows on each page

Post by HansV »

Select File | Page Setup... and activate the Sheet tab (Excel 2003 or earlier), or click Print Titles in the Page Setup group of the Page Layout tab of the ribbon (Excel 2007 or later).
Look for "Rows to repeat at top:", if this is set to $2:$3, this would explain the behaviour that you describe. To print rows 1 through 3 on all pages, change it to $1:$3.
x289.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
VegasNath
5StarLounger
Posts: 1185
Joined: 24 Jan 2010, 12:02
Location: Wales, UK.

Re: Print top rows on each page

Post by VegasNath »

I learn something new every day, Thanks!
:wales: Nathan :uk:
There's no place like home.....