Printing header row on each page

  • Thread starter Thread starter Phyllis Humrich
  • Start date Start date
P

Phyllis Humrich

I know I've done this a million times, but I'm suddenly
braindead. How can I print the header row on each page?
Thank you
 
Phyllis

Go to File/Page Setup/Sheet and set what you want in 'Rows to repeat at top'

Andy.
 
Are you really talking about "page" or "sheet" ... worksheet that is ?

A header will automatically print on every *page* of a worksheet, if a
worksheet spans more then 1 *page* of print ... And of course ... IF you did
make a Header.

If you mean how do you copy the header in PageSetUp from one *sheet* to all
the other *sheets*, then do this:

Select the sheet tab of the sheet that has the header already configured.
Hold down <Ctrl> and select the rest of the sheet tabs that you wish to copy
the header to.
When you release <Ctrl>, make sure that the sheet tab of your already
configured sheet is in *bold*.

Now, just go to <File> <PageSetUp>,
And click <OK>.

Before you forget, *Ungroup* your sheets right away.

One thing to remember - besides copying the headers to all the other
selected sheets, you also copied the entire PageSetUp configuration of your
*main* sheet to all the other selected sheets.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




I know I've done this a million times, but I'm suddenly
braindead. How can I print the header row on each page?
Thank you
 
Back
Top