We help IT Professionals succeed at work.

Print Excel Workbook to PDF

Hi,

I have an Excel workbook that contains data in multiple tags.

I am trying to export to a PDF file but I know see the first page when I opened the PDF file.

Please advise how I can do this.

Thanks.
Comment
Watch Question

ITSysTechSenior Systems Administrator
Commented:
Have you tried using "save as" then chose PDF?
Technical Advisor
Commented:
As suggested above,  File >> save as >> Browse  >> PDF >> Options

1.png

If you have installed Adobe PDF then :

Print >> Adobe PDF ready >> Print Entire Workbook.

4.png
Rob HensonFinance Analyst
Commented:
If you only want certain tabs printed, rather than the whole workbook, you can select multiple tabs and the print will only print those that are selected.

If the tabs are all next to each other, select the first tab and hold shift and then select the last tab; all tabs between will be selected.

If not next to each other, select one tab and then hold Ctrl while you select each of the other tabs.

One issue with printing multiple tabs is if you have headers or footers on any of the tabs. There will be no recalculation event between printing each tab so the Header/Footer settings won't change. This means that if you have header/footer settings on the first tab you will get the same on each subsequent tab.

Thanks
Rob
ITSysTechSenior Systems Administrator

Commented:
inactive for 14 days