Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Posts
    76
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Each month I create a workbook with ten (or more) worksheets, I would like to be able to set the Page Setup (Page/Margins/Header-Footer/Sheet) on one worksheet and have the same settings applied across the remaining worksheets.

    Is there a Macro I could use to apply all of the custom setting I set up for the 1st worksheet, withou having to go to each sheet and apply all the changes?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can shift+click the first and last sheet's tab and then set the page setup for all of them. Then save the empty file. Next time, open that file and you're good to go.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    And if you forget to select all sheets when doing the initial setup, you can replicate the first sheet's setup by immediately selecting the remaining sheets and pressing F4.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    Star Lounger
    Join Date
    Mar 2006
    Posts
    76
    Thanks
    6
    Thanked 0 Times in 0 Posts
    thanks for the tips, it will save me a lot of time!!! have agreat week!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •