"headers"

[aletoconstco]

Is there a way that a header row can be printed on each page of
multipage document without manually inputing the header row at th
start of each page. We may be adding more information to a page tha
will cause the "page breaks" to change on each page.

Thank you
An

 

[Paul B]

Ann, file page set up, sheet, rows to repeat at top $1:$1, or you can click
in the field and select the rows you want with the mouse

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"aletoconstco" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

File|Page Setup|Sheet tab
You can specify rows to repeat at top.

You may want a header, too.
file|Page setup|header/footer tab

ps. You can also freeze panes so that when you scroll down your data, you can
always see the header on the screen.

Say you want to always see rows 1 and 2.

Select A1 (just to make sure it's on the screen)
select A3
window|freeze panes.

 

[R..VENKATARAMAN]

is there not a provision in pagesetup-sheet-rows to repeat at top



"aletoconstco" <[email protected]>
wrote in message
news:[email protected]...

 

[Gail]

You need to go to File Page Setup then click on Sheet and select your rows.
This can not be done through Print Preview - Page Setup