How can I print frozen panes to appear above print selection in Ex

G

Guest

I have selected a print area in Excel but I want the panes frozen at the top
of the page (which contain a description of the various columns) to be
printed as well. How do I do it?
 
D

Dave Peterson

Include those rows in your print range.

If you mean you want those same headers to appear on each of the printed sheets,
then file|page setup|sheet tab and use "rows to repeat at top".
 

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

Print Frozen Panes? 2
frozen panes 2
Unable to freeze panes 16
Hyperlink to move the cursor to the top of the frozen panes 3
Freeze panes grayed out 3
Unable to print document on one page 6
Freeze 2 horizontal panes 2
How do I get both horizontal and vertical frozen panes in Excell 3

Top