How to copy headers/footers across worksheets

[BruceD]

Can I copy headers and footers from one worksheet to another in a workbook
without copying the entire sheet?

[Gord Dibben]

Bruce

Select the sheet with the header/footer you wnat.

Right-click and "Select all sheets".

File>Page Setup>Headers/Footers and OK your way out.

All sheets will have that setup.

DO NOT FORGET to ungroup the sheets after you're done. What is being done to
one will be done to all.

Could make for some interesting changes<g>


Gord Dibben Excel MVP

On Tue, 11 Jan 2005 13:19:05 -0800, BruceD <BruceD@discussions.microsoft.com>
wrote:

>Can I copy headers and footers from one worksheet to another in a workbook
>without copying the entire sheet?

[Ron de Bruin]

See your other thread

--
Regards Ron de Bruin
http://www.rondebruin.nl



"BruceD" <BruceD@discussions.microsoft.com> wrote in message news:BDF6DF9C-419D-4277-9215-9F5F42C584F6@microsoft.com...
> Can I copy headers and footers from one worksheet to another in a workbook
> without copying the entire sheet?

[John]

Gord

You've just saved me from throwing the PC out the window.
I can't understand why this, clearly useful, feature can't be found in the
Excel Help facility.

maybe I should have guessed that 'grouping' was the key. Ah well

1,000 thanks.


--
JohnG, UK


"Gord Dibben" wrote:

> Bruce
>
> Select the sheet with the header/footer you wnat.
>
> Right-click and "Select all sheets".
>
> File>Page Setup>Headers/Footers and OK your way out.
>
> All sheets will have that setup.
>
> DO NOT FORGET to ungroup the sheets after you're done. What is being done to
> one will be done to all.
>
> Could make for some interesting changes<g>
>
>
> Gord Dibben Excel MVP
>
> On Tue, 11 Jan 2005 13:19:05 -0800, BruceD <BruceD@discussions.microsoft.com>
> wrote:
>
> >Can I copy headers and footers from one worksheet to another in a workbook
> >without copying the entire sheet?
>
>

[dinocm]

Gord - THANK YOU so very much! That works slick as a whistle!

"Gord Dibben" wrote:

> Bruce
>
> Select the sheet with the header/footer you wnat.
>
> Right-click and "Select all sheets".
>
> File>Page Setup>Headers/Footers and OK your way out.
>
> All sheets will have that setup.
>
> DO NOT FORGET to ungroup the sheets after you're done. What is being done to
> one will be done to all.
>
> Could make for some interesting changes<g>
>
>
> Gord Dibben Excel MVP
>
> On Tue, 11 Jan 2005 13:19:05 -0800, BruceD <BruceD@discussions.microsoft.com>
> wrote:
>
> >Can I copy headers and footers from one worksheet to another in a workbook
> >without copying the entire sheet?
>
>

[Laura]

I tried following these steps but it didn't work! I selected the sheet with
the header/footer I wanted, then fI right-clicked "select all sheets", then I
did the page setup, headers and footers. But when I went to the other sheets
there was nothing there. Please help me!
Laura

"dinocm" wrote:

> Gord - THANK YOU so very much! That works slick as a whistle!
>
> "Gord Dibben" wrote:
>
> > Bruce
> >
> > Select the sheet with the header/footer you wnat.
> >
> > Right-click and "Select all sheets".
> >
> > File>Page Setup>Headers/Footers and OK your way out.
> >
> > All sheets will have that setup.
> >
> > DO NOT FORGET to ungroup the sheets after you're done. What is being done to
> > one will be done to all.
> >
> > Could make for some interesting changes<g>
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Tue, 11 Jan 2005 13:19:05 -0800, BruceD <BruceD@discussions.microsoft.com>
> > wrote:
> >
> > >Can I copy headers and footers from one worksheet to another in a workbook
> > >without copying the entire sheet?
> >
> >