Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

MS Excel Header and Footer

Apr 20, 2007 1:38AM PDT

Hello everybody,
I would like to know is there a way to put the same Header and Footer in every sheet of a workbook in MS Excel; rather than copying and pasting the same thing onto every sheet individually!
I would be really grateful if anybody could advise me on how to do this.

Thank you!

Discussion is locked

- Collapse -
(NT) Write a macro to do that.
Apr 20, 2007 3:29AM PDT
- Collapse -
Thank you!
Apr 20, 2007 7:51PM PDT

Thank you so much for your help!! Happy

- Collapse -
I assume ....
Apr 20, 2007 11:56PM PDT

this is ironic. But I won't offer to do it for you, so if no volunteer comes along, it's up to you.

Kees