Excel doc (with multiple tabs) to pdf doc

Posted on 2011-05-12
Last Modified: 2012-05-11
 We sort of know how to save a Excel spreadsheet as a pdf document if there is just one tab in the spreadsheet.  However, if there is more than one tab (like 10 tabs) in the workbook, how do I save all the tabs together as one pdf?  Do we have to save each tab and then combine all pdfs into one or is there a simpler way to do this where we can save the entire workbook as one pdf file?
Question by:IT_newbie01
    LVL 17

    Expert Comment

    You didn't say what version of Excel or Acrobat.  But here is a shot of excel 2007 and Acrobat 8.  I went to the Acrobat tab and selected Create pdf.  As you can see from the pic i have the ablity to add whichever sheets i wish.
    LVL 5

    Accepted Solution

    You can do it all at once.  I would recommend downloading Microsoft Save as PDF or XPS and installing it.  It's a free tool from Microsoft to save Office as a PDF.

    You just hit File -> Save As and select PDF.  Go into Options and then make sure you select Entire workbook.
    LVL 23

    Expert Comment

    by:Brian Gee
    If from Excel 2010, File > Save As > Save as type: PDF > click the Options button > Entire Workbook radio button > OK > Save.
    LVL 5

    Expert Comment

    That is true, you didn't mention what version of Excel, but I am using 2010.
    LVL 12

    Expert Comment

    Click "Save as" choose 'Adobe PDF'.  When the Acrobat PDFMaker pops up choose the radio button for "Entire Workbook".

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now