Since reports print exactly as they appear on the screen, make sure you preview your report before printing. The preview will show you whether you need to adjust column width or change page orientation or size before printing.
You must have a printer set up in Windows to access this functionality; otherwise, you will see a warning message.
- Open an existing pivot report, as described in View a pivot table (Pivot Table Explorer).
From the report File menu, click Export > Preview.
The Print Preview window displays the selected report exactly as it will appear when it prints.
Use the toolbar at the top of the page to scroll through the pages.
- To adjust settings, click Settings toolbar button . To learn how to apply the changes, see Adjust pivot report print settings.
- When you are satisfied with how the report looks, click the Print toolbar button , and follow any instructions on your screen.