Column Titles on top of every printed page

  • Thread starter Thread starter Alejandra
  • Start date Start date
A

Alejandra

Hi,

I would like to know how to keep all column titles on top of every page
when I print them. On the screen I just freeze panes, but when I print a
large file with hundrets of rows I get the problem.

Thank you.
Alejandra
 
File>page setup, select sheet then rows to repeat at top

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 

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 Titles 1
Print headings/labels on every page 3
Printing labels at the top of multiple pages 4
Remove page titles from only one page 1
how do I freeze my column labels so that they print every page? 1
Print Titles: Repeating both left column and top rows 2
How to set up Excel to print wrapped columns on a page. 1
Continued Column titles 1

Back
Top