MacNewbeee

Q: How do I print multiple tabs in excel to one pdf

I am using Excel for Mac 2011 and want to select multiple tabs and have this print to one pdf file.  I can print to a normal printer, and have done this for years on a PC, but the Mac pdf function seperates it into seperate files.  I am happy to buy an aftermarket soeftware program for a reasonable price.

OS X Mountain Lion (10.8.1)

Posted on Sep 14, 2012 4:26 PM

Close

Q: How do I print multiple tabs in excel to one pdf

  • All replies
  • Helpful answers

Previous Page 2
  • by eastwoodac,

    eastwoodac eastwoodac Nov 23, 2015 4:11 AM in response to MacNewbeee
    Level 1 (0 points)
    Nov 23, 2015 4:11 AM in response to MacNewbeee

    I have same problem. Need to print all tabs in excel with different page set ups to a single pdf. Wasted half of morning trying to sort this out on my Mac. Just got my old windows xp machine out c/w office 2000 and sorted it in seconds. Can this be done on the Mac as this is a regular requirement for me and cannot afford to waste time rebuilding the pdf's manually all the time?

  • by Barney-15E,

    Barney-15E Barney-15E Nov 23, 2015 4:39 AM in response to eastwoodac
    Level 8 (49,856 points)
    Mac OS X
    Nov 23, 2015 4:39 AM in response to eastwoodac

    eastwoodac wrote:

     

    Can this be done on the Mac as this is a regular requirement for me and cannot afford to waste time rebuilding the pdf's manually all the time?

    Well it seems Microsoft "fixed" this problem in Office 2016 by converting all the pages to the page layout of the active tab when you print or save as PDF.

  • by eastwoodac,

    eastwoodac eastwoodac Nov 23, 2015 4:57 AM in response to Barney-15E
    Level 1 (0 points)
    Nov 23, 2015 4:57 AM in response to Barney-15E

    Yes I do believe this is a Microsoft downgrade between Excel 2000 & Excel 2013. Just tried on Excel 2013 under Windows 7 and it splits the pdf's to separate pages like it did on the Mac. Sorry Apple it was Microsoft's fault. Will continue to use office 2000 as the ribbon is simply no use to productivity at all either.

     

    The good old days when things used to work.

Previous Page 2