+ Reply to Thread
Results 1 to 4 of 4

Printing Side by Side on Same Page

  1. #1
    Forum Contributor bentleybob's Avatar
    Join Date
    02-27-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    644

    Printing Side by Side on Same Page

    A user has a very long but narrow spreadsheet he wants to print. But he wants it to print, say, the first 20 rows at the left of the page (in Landscape), the next 20 rows in the middle of the page, and the next 20 rows at the right. Then this would continue for however many pages is needed.

    Ideas?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Printing Side by Side on Same Page

    I would do this by writing a macro to copy the data onto another worksheet in the desired output format. How many columns of data are being used?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor bentleybob's Avatar
    Join Date
    02-27-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    644

    Re: Printing Side by Side on Same Page

    Your macro approach would certainly work, so thanks for suggesting it. But I was hoping for an Excel or print setup feature I was unaware of to give him a more direct and flexible solution. One thing I had hoped would work but doesn't is to go into Printer Properties and select multiple sheets under Page Layout. But this prints multiple pages in Portrait mode even though it's set to Landscape, or the print is ridiculously tiny.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Printing Side by Side on Same Page

    The only other idea, one that is not so good, is to copy the data to Word and then select the option for three columns. Word knows all about printing in multiple columns. Excel, not so much.

+ 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