printing freeze pane

W

Windseaker

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.
 
G

Gord Dibben

File>Page Setup>Sheet>Rows to repeat at top.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Freeze Pane Saving 10
How do I freeze/ unfreeze a window pane in Excel 2007? 2
How do I use freeze pane and split in the same excel spreadsheet 2
Trouble with Titles - Excel 2007 2
freeze and split at the same time? 1
When optioning Freeze Panes below header row cannot scroll down 1
Freeze pane 2
Freeze multiple rows/columns in Excel 2007 11

Top