Printing page headers (first 4rows)

[StevenK]

I'm producing some reports in Microsoft Excel (so far I've got data feeding from an SQL Server database, have conditionally coloured rows, etc.).
What I now need to do is allow the user to print the pages - ideally I want them to get the same information at the top of each page (i.e. report title [indicating the date range as run], etc.)

When I set this page to Preview / Print - these details (held in the first 4 rows or so) only display / print at the top of the first page.
Is there any means to get these same rows to print at the top of each page that is displayed / printed?

Any advice would be greatly appreciated.
Steve

 

[BlueHorizon]

Hi,
In the File/Page Setup dialog box, click on the Sheet tab. Click in the Rows to repeat at top box and select the rows on your worksheet that fit the category. Click OK. Observe the results in Print Preview.

HTH,

Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[StevenK]

Excellent - that option works as required for me.
Thank you again.
Steve