I recently had a user call in and ask me how he could export the contents of a single worksheet to PDF while working in Microsoft Excel 2010. As I told him, that is a simple feat to achieve. Here is how:
- Click File, then Save as…
- Change the format in which to save to PDF
- Click the Options-button that will have appeared
- Select what to save to PDF
You are not only offered the opportunity to export an active worksheet, you can also choose to export only a selection within the active worksheet.