We help IT Professionals succeed at work.

Print Excel Workbook to PDF


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.

Watch Question

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


If you have installed Adobe PDF then :

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

Rob HensonFinance Analyst
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.

ITSysTechSenior Systems Administrator

inactive for 14 days