Headers & footers

Question

I have several workbooks that contain multiple tabs and all require the same footer, is there a way to apply the footer to all pages with one command or will I need to manually add it to each tab. If no one has thought of this before it would I think it would be a great addition

Answer 1

Hi @Bruce Norman

You can do this without code:

1) Go to the tabs at the bottom > Right click > Select All Sheets

2) Go to Insert > Header & Footer

3) Press Go to Footer

4) Enter the desired Footer and it will be applied to all of the sheets.

---

If this is helpful please accept answer.