Column Titles on top of every printed page

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
 
P

Peo Sjoblom

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

how do I freeze my column labels so that they print every page? 1
Remove page titles from only one page 1
Continued Column titles 1
Print Titles 1
How to keep Column headers with Autofilter & Freeze Panes 8
Print headings/labels on every page 3
Printing column label on every page. 2
MS Excel Freeze panes based on selection does not work for me 4

Top