printing multiple pages

M

mike

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
 
Top