Headers & footers

Bruce Norman 21 Reputation points
2022-11-02T15:23:03.953+00:00

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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,715 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dillon Silzer 57,491 Reputation points
    2022-11-02T19:16:46.813+00:00

    Hi @Bruce Norman

    You can do this without code:

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

    256447-image.png

    2) Go to Insert > Header & Footer

    256552-image.png

    3) Press Go to Footer

    256504-image.png

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


    If this is helpful please accept answer.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.