1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Resolved Excel: Set Header for all Worksheets in Workbook?

Discussion in 'Other PC Software' started by Rick_E, 2011/05/06.

  1. 2011/05/06
    Rick_E

    Rick_E Inactive Thread Starter

    Joined:
    2004/01/06
    Messages:
    26
    Likes Received:
    2
    In an Excel workbook, setting a header and footer seems to be specific to the currently selected sheet. Is there a way to set a header and footer that will be used on all of the worksheets? Thanks.
     
    Last edited: 2011/05/06
    Rick_E,
    #1
  2. 2011/05/06
    Rick_E

    Rick_E Inactive Thread Starter

    Joined:
    2004/01/06
    Messages:
    26
    Likes Received:
    2
    I found the answer from something said in another thread. To set the header and footer for all worksheets at once,

    * Right-click on the tab for the first sheet and choose Select All Sheets
    * Set the header and footer
    * Deslect the other worksheets by left-clicking on the tab for the first sheet.

    Thanks.
     
    Last edited: 2011/05/06
    Rick_E,
    #2


  3. to hide this advert.

  4. 2011/05/06
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Thanks for the update :)
     
    PeteC,
    #3

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...