software

I need to have the same 4 rows on the top of every page when it prints. I
know that there is a way to do it, i just have forgotten, Could someone
please freshen my memory. My example is I am putting a different amount next
to every zip code in the state of TX. So obviously this is many pages, but
instead of copy/paste these for cells on top of every page I just want it to
be there when I print. But I don't want to use the HEADER/FOOTER option,
hence I need to use that for the correct purpose. Please help.
Thanks

Hi

Go to File/Page Setup/Sheet tab. There is a box for 'Rows to repeat at top'.

Andy.

quot;Shanonquot; gt; wrote in message
news
gt;I need to have the same 4 rows on the top of every page when it prints. I
gt; know that there is a way to do it, i just have forgotten, Could someone
gt; please freshen my memory. My example is I am putting a different amount
gt; next
gt; to every zip code in the state of TX. So obviously this is many pages, but
gt; instead of copy/paste these for cells on top of every page I just want it
gt; to
gt; be there when I print. But I don't want to use the HEADER/FOOTER option,
gt; hence I need to use that for the correct purpose. Please help.
gt; Thanks