+ Reply to Thread
Results 1 to 2 of 2

printing multiple sheets on one page

  1. #1
    Registered User
    Join Date
    06-21-2007
    Posts
    25

    printing multiple sheets on one page

    Is there a way to print content from different sheets in a workbook on a single sheet of paper? For example, the print area of sheet 1 on the top half of the page and the print area of sheet 2 on the bottom half.

    I know I could aggregate the content on one sheet in various ways, but it's more of a formatting issue -- I want to use different column widths and row heights for each print area.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning pete_22
    Quote Originally Posted by pete_22
    Is there a way to print content from different sheets in a workbook on a single sheet of paper?
    Ole P Erlandsen provides a solution here :
    http://www.erlandsendata.no/english/...intmultiselect

    Or John Walkenbach's Pup6 will do this for you if you want a ready made solution (Pup v6 > Printing > Print Multiple Selection Wizard). You can download a fully working evaluation copy from here, but if you like it and continue using it you should register it :
    http://j-walk.com/ss/pup/pup6/trial.htm

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to 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