ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   printing headers on every page (https://www.excelbanter.com/excel-discussion-misc-queries/114361-printing-headers-every-page.html)

Sam Hodo

printing headers on every page
 
Hi;

I would like to print out rows 1 and 2 on a spreadsheet on every page of a
30+ page report.

Problem is that when I file, print preveiw, setup, sheet
I can not get the print titles area to let me select..

How do I turn this feature on for all future excel worksheets.

Thanks for you time and effort.

Sam


Ron de Bruin

printing headers on every page
 
Use FilePagesetup...Sheet Sam

you can do it there

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sam Hodo" wrote in message ...
Hi;

I would like to print out rows 1 and 2 on a spreadsheet on every page of a
30+ page report.

Problem is that when I file, print preveiw, setup, sheet
I can not get the print titles area to let me select..

How do I turn this feature on for all future excel worksheets.

Thanks for you time and effort.

Sam




Sam Hodo

printing headers on every page
 
Ron

Thanks


"Ron de Bruin" wrote:

Use FilePagesetup...Sheet Sam

you can do it there

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sam Hodo" wrote in message ...
Hi;

I would like to print out rows 1 and 2 on a spreadsheet on every page of a
30+ page report.

Problem is that when I file, print preveiw, setup, sheet
I can not get the print titles area to let me select..

How do I turn this feature on for all future excel worksheets.

Thanks for you time and effort.

Sam






All times are GMT +1. The time now is 10:32 PM.

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