In Excel you can us Save As to save a file as a pdf, but it isn’t quite as effective in Excel as it is for MS Word. Often you only want to save a single sheet or a few sheets to pdf. Try this.
I use a free Windows App called CutePDF Writer. It is OK to use it for commercial use – see image below from their website.
This app works just like a printer. You make your printing selections as per normal and then select CutePDF Writer as your printer and Print.
It opens a dialog where you can select what to call the file and where to save it.
Click the button below to see more details of CutePDF Writer and to download it.
If you are interested in using a macro to automate the pdf process you can check out the button below to go to Ron DeBruin’s site. His page has lots of resources on pdf and emailing.