ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   printing freeze pane (https://www.excelbanter.com/excel-discussion-misc-queries/223096-printing-freeze-pane.html)

Windseaker

printing freeze pane
 
I know how to freeze a pane in excel, but how do you make a coustom pane that
will print out each time or each page. Not just a "header". Running XP pro w/
Office 2003.

Gord Dibben

printing freeze pane
 
FilePage SetupSheetRows to repeat at top.

Select the rows in the refedit box or just type in 1:2 or whatever.


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 15:21:02 -0800, Windseaker
wrote:

I know how to freeze a pane in excel, but how do you make a coustom pane that
will print out each time or each page. Not just a "header". Running XP pro w/
Office 2003.




All times are GMT +1. The time now is 10:46 AM.

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