+ Reply to Thread
Results 1 to 4 of 4

Printing grouped worksheets

  1. #1
    Registered User
    Join Date
    02-14-2017
    Location
    Johannesburg, South Africa
    MS-Off Ver
    MS Office Home and Business 2010
    Posts
    2

    Printing grouped worksheets

    I have a Excel file open with more than one worksheet.
    I have formatted WS1 to print in portrait orientation, WS2 to print in landscape orientation, WS3 to print in landscape orientation, WS4 to print in portrait orientation etc....

    The worksheets have been grouped for printing.
    However, when printing happens, all are printed in portrait orientation. Can Excel not print them in the orientation that was originally ordered?

    Await reply and thank you for your time.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Printing grouped worksheets

    record a macro, which prints needed sheets and execute it

  3. #3
    Registered User
    Join Date
    02-14-2017
    Location
    Johannesburg, South Africa
    MS-Off Ver
    MS Office Home and Business 2010
    Posts
    2

    Re: Printing grouped worksheets

    Thank you Tim20110. I have been using Excel most of my life and believe it or not, I do not know how to use the: record a macro function.
    Where can I read up on it and how do I go about it, please?

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Printing grouped worksheets


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Consolidating Grouped Worksheets into one 'Master' Workbook
    By scruz9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2016, 08:50 AM
  2. Printing "grouped" pie charts on 1 single page
    By Vegiepie2016 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-06-2016, 01:56 PM
  3. [SOLVED] Selecting grouped worksheets
    By trisoldee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2014, 11:08 AM
  4. Grouped rows disabled when Protecting worksheets!
    By DaveRimmer in forum Excel General
    Replies: 9
    Last Post: 11-27-2013, 12:18 AM
  5. Problem Printing grouped rows.
    By Granddad in forum Excel General
    Replies: 3
    Last Post: 08-19-2013, 05:00 PM
  6. [SOLVED] Creating Grouped Worksheets
    By Janie in forum Excel General
    Replies: 2
    Last Post: 07-18-2013, 09:05 AM
  7. [SOLVED] protect/unprotect grouped worksheets
    By Todd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2005, 12:45 PM

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