Apear Freeze panes when printing

P

Pedro Mestre

Dear all,

We have a worksheet that we want to apear the first line of data base in
each printed sheet, like Freeze panes lock it when you are scroling.

Is it possible?

Thanks a lot.

Kind regards,
Pedro Mestre
 
A

Alan

Go on to 'File' > 'Page Setup' > 'Sheet' and enter the rows you want on each
page in the 'Rows to repeat at top' box,
Regards,
Alan.
 

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

Export SAP to Excel 97 Ok, Excel 2003 Error 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Update of linked files 1
Number of Columns 2
Freeze Pane Macro 1
Outlook Mail Merge error 1
freeze and split at the same time? 1
Protect Workbook 1

Top