Printing frozen panes on all pages

[7138]

Hi there. I am trying to print a chart and when the other pages are printed, the frozen panes are not showing up. I have gone to the Page Set Up, Sheet tab, but the "rows to repeat at top " are not visible to change. Is there somewhere else to access the information to have the rows printed?

 

[Steve=True]

Hi 7138, welcome to the forums!

From the Print Preview Window, It is always greyed out for me when i try and repeat rows or columns or change the print area.

You will need to go to the Print Titles group in the Page Layout Ribbon (excel 2007) to change this. It is Page Layout in 2003, but can't remember how to get there in 2003.


Steve=True
www.exceldashboardtemplates.com

 

[7138]

Ah, that's the trick - thanks a bunch!!!!