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?

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.

"Pastor Rod" wrote:

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?

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

On Thu, 13 Jan 2005 09:19:05 -0800, "LoriM"
wrote:

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.

"Pastor Rod" wrote:

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?