Converting Excel file to Adobe Acrobat 8 PDF file -- fit to page option?

I have Adobe Acrobat Professional version 8.
I have an excel workbook (with 6 sheets) that I would like to convert to a PDF doc.
When I do the conversion, since the spreadsheet is too wide and too long to fit on a single page, it creates multiple pages for the same sheet in the PDF file.  Is there a "fit to page" option (at least for the width) that I can use??
LVL 9
sah18Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SysExpertCommented:
Why don'y you use the scaling option to make it smaller.
Also have yo tried using the free
openoffice.org that has built in PDF conversion.

I hope this helps !
0
sah18Author Commented:
Where can I find the scaling option?

Well, we already own Acrobat, so it seems there's not really a need for another package at this point (unless it has features that this one doesn't (?))
0
SysExpertCommented:
Since i is free, you may want to try it to see if it has more options.

Is there a print to PDF option as part of Acrobat. This would offer scaling options I think.

I hope this helps !
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

dgbutterworthCommented:
I am not sure what you want to do, exactly, so I will guess.  Assuming you want to make your printout fit in a one page pdf file, Acrobat has some interesting page sizes.  I have not yet upgraded, but in ver. 7 Pro there is an "oversize A2" (for example) "paper size."  I tested this size by printing a large spreadsheet, and the output looks great.  The resulting pdf document properties report the "paper size" as 26.81x18.90 inches.  I might have to go buy a printer, so I can play with this some more.  If this is what you want, you can achieve this from Excel during the print  -> open the print window (e.g. ctrl-P), select your Adobe PDF printer, select properties, and in "advance" you can find some interesting paper sizes.  (I only tested, successfully, the Oversize A2.  There is a "screen" paper size, which is an interesting idea, but I got strange results with that.)  Good luck, DGB
0
RayData AnalystCommented:
Why not just set your print options within Excel to the correct parameters for paper output. Then instead of printing to your printer, just print to the PDF printer driver that is included with Acrobat 8. This will give you the output you previously set up.

"Converting" files always yields unexpected results.  Save yourself the headache and just print it to the PDF printer driver.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dgbutterworthCommented:
rlistenb - that is exactly what I meant.  It was not clear?  Of course, printing to a "large paper size" in acrobat seems unnecessary, unless you actually have a printer that can print 19x26 inches.  If you simply want a pdf file, I believe you could print to a normal "size" page and then enlarge the view.
0
sah18Author Commented:
rlistenb - your suggestion worked perfectly!  we had already set the printing options in excel previously (so that printing directly from excel looked the way we wanted), but we were not creating the pdf via printing to adobe pdf.  we were either:
1. using the button in excel to convert to pdf
or
2. right-clicking on the filename itself (outside of excel), and selecting the convert to pdf option.
neither of these options retained the printing preferences we had set from within excel.
Your's did!
thanks for all suggestions!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Acrobat

From novice to tech pro — start learning today.