Headers/Footers

J

Jane

I'd like to use the same header on all worksheets of a workbook. I
there a function to do this only once rather than adding the header t
each individual worksheet
 
R

RagDyer

First, setup one sheet that is to your liking.

Then, hold <Ctrl> and click in the tabs of the rest of the sheets that you
wish to have the same settings (group the sheets).

You must *be sure* that the MAIN sheet ( sheet to be copied *from*) has the
focus, where the tab is in bold.

Then, simply:
<File> <PageSetUp> <OK>.

Now, all the selected sheets have exactly the same Page Set Up settings,
including all the print settings.
--

HTH,

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

I'd like to use the same header on all worksheets of a workbook. Is
there a function to do this only once rather than adding the header to
each individual worksheet?
 
D

Dave Peterson

Try selecting all the worksheet tabs you want with the same header/footer.

click on the first, ctrl-click on subseqent
(or rightclick on one and choose "select all sheets")

the do your file|page|setup to change your header/footer.

Remember to ungroup your sheets when you're done. If you don't, then anything
you do to one will be done to the rest of the group!

(Excel tries to help you by adding [Group] to the title bar.)
 
Top