printing multiple pages

G

Guest

Hi to everyone,
I have one spreadsheet about 8 pages, when the time I print my spreadsheet
the header or the title was only appeared or show in the first page. What I
wanted is when I print my worksheet all pages have a header or a title.

thanks,
mike
 
J

JMay

Goto File PageSetup...
The 4th tab Sheet -- look for Titles - Rows to repeat and enter in the
box
Example -->>> $1:$5
& Ok Out
 

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

Not all pages printing in Excel 2007 1
Printing Excel 2
F at the top of the page 1
Prints too many pages 5
Printing header rows.. 5
Change print titles (rows to repeat at top) on subsequent pages 2
Printing multiple tabs 3
Print Titles - Columns to Repeat at Left 1

Top