In Excel, how do I make the freezed pane area, print on each page.

G

Guest

I have a spreadsheet and I freezed the top part of the page like 4 lines, I
want that section to always print, without having to cut and paste with page
breaks. I have a few reports that do that, but i can't figure out how to do
myself. Office 2000
 
D

Dave Peterson

File|page setup|Sheet tab|
Click in the Rows to repeat at top.
Point at your rows with your mouse.
 

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

Using freezed panes in excel, how do I save the page as HTML? 1
How to remove dashed page lines after using print preview 1
Print Area 2
How can I expand print area to whole page? 8
Print area won't change 8
How do I print the names of my columns on each page? (Excel) 1
Set Print Area & print on one page 2
Why does my print area suddenly besome minute in the page preview 1

Top