I have used the freeze pane feature in Excel. So that the top 2 rows and the columns have been frozen…..

When clicking on Print Preview, I want the frozen panes to be printed on every page… currently when printing it doesn’t hold the frozen panes on each page….

I have attached the worksheet I am using currently

Please note that it works in ‘Nurse’ worksheet and not for ‘Summary Top Sheet’

Thanks in advance

Go to File > Page Setup > Sheet (last tab). Then you can choose which rows to repeat on each page. When you click the button it will allow you to select the entire row(s). You have to do that for each worksheet.

once again you provided a quick and clear answer... thanks very much...