Printing the first two rows as headers.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. Michael Morse - 20 Sep 2006 17:05 GMT

I would like to have the first two rows print at the top of every page
of my print out. I know this is a basic function, yet I can not seem to
find it in the help function. Could someone please post how to do
this /AND/ tell me what key words to put in the search/help function
that would show the answer as well.

Thanks

Michael

Signature

J. Michael Morse
michael@stignatius.cc <mailto:michael@stignatius.cc>

St. Ignatius <C:/Parish%20Administration/Graphics/Bulletin/Ignatius2C.jpg>

"Let no one ever come to you without leaving better and happier." -
Mother Teresa

Reply to this Message

Niek Otten - 20 Sep 2006 17:20 GMT

Hi Michael,

File>Page Setup, Sheet tab, Rows to repeat at top

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I would like to have the first two rows print at the top of every page
| of my print out. I know this is a basic function, yet I can not seem to
[quoted text clipped - 5 lines]
|
| Michael

Reply to this Message

Dave Peterson - 20 Sep 2006 17:22 GMT

File|Page setup|Sheet Tab|
type: 1:2
in the rows to repeat at top box.

> I would like to have the first two rows print at the top of every page
> of my print out. I know this is a basic function, yet I can not seem to
[quoted text clipped - 14 lines]
> "Let no one ever come to you without leaving better and happier." -
> Mother Teresa

Signature

Dave Peterson

Reply to this Message

Bernard Liengme - 20 Sep 2006 17:33 GMT

Also note you cannot enter the row values if you open the SetUp dialog from
within PrintPreview; you must use the File|PageSetup route.

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I would like to have the first two rows print at the top of every page of
>my print out. I know this is a basic function, yet I can not seem to find
[quoted text clipped - 5 lines]
>
> Michael

Reply to this Message