Convert Excel worksheets to PDF file. Help

[wyarbrough]

I need help converting Excel worksheets to a PDF file. I have a fairly complicated file (at least for me) that is used by construction estimators. The file consists of about 12 worksheets and contains hundreds of formula, checkboxes, etc. At present the estimators print out only the relevant part of each worksheet after they enter the job details, then scan the print outs to create a PDF file, then email the PDF file to our field offices. I am looking for an efficient method to directly create PDF file of only the print range portion of each worksheet. I really just need a duplicate of the print in PDF format. I do not need hyperlinks, metadata, or anything fancy in the PDF. I have read about the “click-to-convert” program, “metadata assistant”, and “verypdf” and maybe an Adobe product would work, but I have no experience with any of them. Cost is really not an issue, the company will buy whatever works best. The gurus on this forum have saved me several times before, and I hope you can do it again. (If I failed to properly explain, let me know and I’ll try again) Thanks in advance to all.

 

[SydneyGeek]

I use PDF Create from ScanSoft. It probably doesn't matter which you use -- the process should be the same.

1. Install PDF creation software
2. In Excel,
a. select the section to print (if part of a worksheet) then File > Print > Selection
b. To print the worksheet, File > Print
3. Select the printer. Use the PDF driver
4. Follow the prompts to save the file


EDIT: You can also help the users by selecting the relevant section of each worksheet, and File > Print Area > Set Print Area.

Denis