Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Los Angeles, CA, USA
    Posts
    3
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Trying to print two Excel half-page spreadsheets on ONE piece of paper - and hopefully a PDF file.

    I have two separate Excel spreadsheets that each take up half a (printed) page. The column and row widths are completely different in each (so I can't just copy one sheet below the other). I've set margins to allow Sheet 1 to print on the top half of a page, Sheet 2 the bottom half. To print, I would just run the paper through twice, so both sheets end up on the one piece of paper. (For example, a crossword puzzle, where the clues are from one spreadsheet and the grid from another, each with different formatting.)

    I want to do the same thing, but create a PDF that combines them both on the same page (i.e., "Print as PDF"). I could print the two-pass, one-paper page and then scan it to a PDF, but the quality loss is unacceptable. Same with copying and pasting into a new file.


    The scan I'm including shows the desired result - the top 2/3rds is a separate Excel sheet from the bottom third (the answer box grid). This is my annual Christmas "card" that I've always snail-mailed, but this year I want to also have it as a downloadable PDF. Example: https://1drv.ms/b/s!AgCTbLJh09_XkQcW1L8Pz8H-9BCh

    Is there a way to combine both sheets into one "Print as PDF" file without having to lose quality? (This is my Christmas "card," so time is of the essence!)

    When I use the "Combine files" option in Acrobat DC, the two sheets come out as separate pages in the PDF.

    Help! And thank you all in advance, very very much! Happy holidays! -- Ron

  2. #2
    2 Star Lounger Graham Mayor's Avatar
    Join Date
    Mar 2016
    Location
    Cyprus
    Posts
    102
    Thanks
    0
    Thanked 36 Times in 35 Posts
    The fact that you have posted this in a Word forum suggests the way forward. Copy the areas of the worksheet in turn and Paste as a Picture into a Word document, one above the other. The only thing to note here is that Word will shrink the image to the width between the current margins, so the aim will be to ensure that the worksheet area copied is not larger than the area between the margins or there will be some compression.

    Add your text at the top and save as PDF.
    Graham Mayor - Word MVP
    http://www.gmayor.com

  3. The Following User Says Thank You to Graham Mayor For This Useful Post:

    Ron90069 (2016-12-17)

  4. #3
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,918
    Thanks
    4
    Thanked 290 Times in 264 Posts
    Graham's suggestion is sound but you don't need to use Word if you prefer to stay in Excel.

    In Excel, you can copy the second page as a Picture and paste it onto the First page so they are together. To do this, add a button on your Quick Access Toolbar for the command called 'Copy as Picture'. Once this is done, you can select the content and then click that button to copy the selection as a graphic. You will be prompted to choose the format/resolution. IMO, Picture and for Printer will give the best result but your mileage may vary. You can then paste that image to the other page and resize to suit.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  5. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    Ron90069 (2016-12-17)

  6. #4
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,149
    Thanks
    0
    Thanked 268 Times in 257 Posts
    Another choice may be to create 2 half-page Text boxes in Word then Copy each spreadsheet and Paste in each Text box. Readability may be an issue.

  7. The Following User Says Thank You to Berton For This Useful Post:

    Ron90069 (2016-12-17)

  8. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,200
    Thanks
    2
    Thanked 467 Times in 380 Posts
    Thread moved to 'General Productivity' - it really has nothing to do with Word Processing, per say.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  9. The Following User Says Thank You to macropod For This Useful Post:

    Ron90069 (2016-12-17)

  10. #6
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    725
    Thanks
    155
    Thanked 21 Times in 19 Posts
    You can print multiple Excel sheets on page. I haven't done it for a long time, but I think this procedure may work: https://www.infopackets.com/news/239...-page-ms-excel

  11. The Following User Says Thank You to Vincenzo For This Useful Post:

    Ron90069 (2016-12-17)

  12. #7
    New Lounger
    Join Date
    Dec 2009
    Location
    Los Angeles, CA, USA
    Posts
    3
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Thank you all for your suggestions!
    Unfortunately, the way I have the two spreadsheets formatted for printing (Print Areas) will need some work. Vincenzo's idea and link provide the most readable results, however I will have to experiment with the sizing of each sheet to make them compatible (i.e. same size in the printout). Here's the first result. The two frames need to go, and the sizing (width) of each part needs to be widened. I think it will be great when I can work out the size issues! I'll post the final result here as soon as I get the details right!
    Worth noting: I posted the same message on the Adobe Acrobat forum a day before posting here, and while it got about 30 views there, not one person replied. It just goes to show how valuable a resource THIS forum (and site) is, and how wonderfully generous you all are with your time and advice!!
    Thank you again, and HAPPY HOLIDAYS!!! -- Ron
    https://1drv.ms/b/s!AgCTbLJh09_XkRIj-Se4zjdodICe
    Attached Files Attached Files

Posting Permissions

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