Excel doc (with multiple tabs) to pdf doc

Posted on 2011-05-12
Medium Priority
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

ID: 35749963
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.

Accepted Solution

Chickensaur earned 1200 total points
ID: 35749966
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
ID: 35749969
If from Excel 2010, File > Save As > Save as type: PDF > click the Options button > Entire Workbook radio button > OK > Save.

Expert Comment

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

Expert Comment

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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

807 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