How do you carry the first row of information to the other pages .

P

Pastor Rod

I want to take the headings from my first page and automatically use them as
headers for the rest of the pages. How do I do that?
 
L

LoriM

Go to "File | Page Setup | Sheet"

Under "Rows to repeat at top" click on the arrow and then select your rows.
I.e., if you want the first three rows to be header for all other sheets, it
will put in $1:$3.

Hope this is helpful to you.
 
G

Gord Dibben

LoriM has made a good suugestion if you want to print the headers on each
page.

If by "pages" you mean "worksheets" and you don't mean when printing, you can
select all the sheets(r-click and "select all sheets") and type your
headers/titles on one sheet and they will be entered on all selected sheets.

DO NOT FORGET to ungroup the sheets when done.


Gord Dibben Excel MVP
 
Top