Closed Thread
Results 1 to 4 of 4

page set-up for multiple worksheets

  1. #1
    Registered User
    Join Date
    11-03-2006
    Posts
    5

    page set-up for multiple worksheets

    Hi everyone,

    when I try to do "page set-up" after selecting multiple worksheets, the all page settings apply to all worksheets selected. For example, all the worksheets get the same header and footer

    I only want to change one factor of the page settings (for example, just scaling) for mutiple worksheets at once, how should I do it?

    Some of my excel files have more than 20 worksheets and I really want to know how to do this.

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by crepe
    Hi everyone,

    when I try to do "page set-up" after selecting multiple worksheets, the all page settings apply to all worksheets selected. For example, all the worksheets get the same header and footer

    I only want to change one factor of the page settings (for example, just scaling) for mutiple worksheets at once, how should I do it?

    Some of my excel files have more than 20 worksheets and I really want to know how to do this.

    Thanks!
    Tools, Macro, Record New Macro, and select any cell, then Stop recording.

    Tools Macro, Macros, macro1(your macro) Edit

    replace the text with
    Please Login or Register  to view this content.
    Adjust the zoom to your required setting.

    Assign a letter to the macro so the CTRL/letter, or CTRL/Shift/Letter will trigger the macro.

    For other settings, record a macro and make the change, Stop the macro and select the required change.

    Hope this helps.
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    11-03-2006
    Posts
    5

    Thanks a lot!

    It worked!!! Thank you so much!!

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by crepe
    It worked!!! Thank you so much!!
    Good to see, and thanks for the response.
    ---

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1