Footer in Excel

[Carol]

How do you copy a footer from one worksheet to another. I don't want to have
to re-type the footer on each page.

[Dave Peterson]

Group the sheets you want to have the same footer.
click on the first worksheet tab.
ctrl-click on the subsequent.

Change the footer

Ungroup the sheets (rightclick on any and choose ungroup sheets)

Carol wrote:
>
> How do you copy a footer from one worksheet to another. I don't want to have
> to re-type the footer on each page.

--

Dave Peterson

[Carol]

Wonderful, it worked. Thank you so much for your help.

"Dave Peterson" wrote:

> Group the sheets you want to have the same footer.
> click on the first worksheet tab.
> ctrl-click on the subsequent.
>
> Change the footer
>
> Ungroup the sheets (rightclick on any and choose ungroup sheets)
>
> Carol wrote:
> >
> > How do you copy a footer from one worksheet to another. I don't want to have
> > to re-type the footer on each page.
>
> --
>
> Dave Peterson
>