Your Excel workbook has three sheets: Summary, Detail, and Charts. You need each sheet exported as a separate page in a single PDF, with the Summary as page 1, Detail as page 2 and beyond, and Charts as the final pages. A simple File, Save As, PDF exports the entire workbook, but what if you only want specific ranges from each sheet, or you need different print settings for each area?
Setting multiple print areas in Excel to PDF gives you precise control over which data appears in the PDF and how it is paginated. Each print area becomes a separate section in the output, with its own page setup, headers, and scaling.
How Excel Handles Multiple Print Areas
Excel can define multiple named ranges as print areas on a single worksheet. Each named range prints as a separate page or set of pages. When you export to PDF, Excel processes each print area in the order they were defined. The first print area becomes the first pages of the PDF. The second becomes the next pages. This ordering gives you control over the PDF's page sequence.
You can also print areas across multiple worksheets. When you export the entire workbook to PDF, Excel processes the sheets in order, using each sheet's print area if one is defined. If no print area is defined, Excel uses the sheet's used range. This sheet-level control lets you mix sheets where you want the full content exported with sheets where you want only a specific range.
Step by Step: Setting Multiple Print Areas on One Sheet
Select the first range of cells you want to include. Go to Page Layout, Print Area, and select Set Print Area. This sets the first print area. To add a second area, select the next range of cells. Go to Page Layout, Print Area, and select Add to Print Area. Excel adds this range as an additional print area. Each print area appears on a separate page in the PDF. Repeat for each additional area.
To view and manage all print areas, go to View, Page Break Preview. Each print area is outlined and labeled with a page number. You can see at a glance which data will appear on which PDF page. Drag the page break lines to adjust where pages break within a print area. The visual preview is more intuitive than managing print areas through dialog boxes.
Using Named Ranges for Cleaner Print Area Management
For spreadsheets where the print areas change periodically, define named ranges instead of using the Set Print Area command. Go to Formulas, Name Manager, and create named ranges for each section you want to export. Name them descriptively: "SummaryTable," "DetailData," "ChartSection." When you export to PDF, you can reference these named ranges directly in the print settings. This approach is more maintainable than manually redefining print areas each time the data changes.
WukongPDF's Excel-to-PDF conversion recognizes named ranges and lets you select which named ranges to include in the export. Select the ranges from a list. Arrange their order. The conversion processes each range and assembles them into a single PDF. This workflow is faster than configuring print areas in Excel and produces the same result.
Configuring Page Setup for Each Print Area
Each print area can have different page setup settings. One area might need landscape orientation because it has many columns. Another might need portrait. One might need a header row repeating. Another might need gridlines visible. Excel applies the print settings that were active when each print area was defined. To change settings for a specific print area, select it, adjust the page setup options, and re-add it to the print areas.
This per-area configuration is powerful but can be confusing because the settings for one area affect the default settings for the next area you define. Work in a consistent sequence: select the area, configure page setup, add to print areas, select the next area. This sequence ensures each area gets the settings intended for it.
Exporting the PDF and Verifying the Output
Go to File, Save As, PDF. Before saving, click Options. Under Publish What, select "Active Sheet" for the current sheet or "Entire Workbook" for all sheets. If you choose Entire Workbook, each sheet with print areas exports those areas. Sheets without print areas export their full content. Click OK and Save.
Open the PDF and verify each print area appears on the correct pages. Check that the page order matches your intended sequence. Confirm that each area's page setup, orientation, scaling, headers, is correct. The PDF Pages should flow logically from one section to the next, with each section clearly separated and easy to identify. For recurring reports, save the Excel file with the print areas configured. The PDF Export settings persist with the file, so each future export produces the same structured output with zero additional configuration.
A practical scenario where multiple print areas shine: an executive dashboard spreadsheet with a summary chart in the top-left, detailed metrics in the top-right, and transaction data below. You want the summary chart as a standalone PDF page for the board presentation, the detailed metrics as a second page for the management team, and the transaction data excluded entirely because it is not needed for the presentation. Define three print areas: one for the chart, one for the metrics, and none for the transaction data. Export to PDF. The output is two clean pages with exactly the content each audience needs, extracted from a single spreadsheet.
When sharing the PDF with recipients who may want to verify the source data, add a footnote on each page indicating the source spreadsheet name, the named range or print area, and the date of export. This provenance information lets the recipient trace the data back to its origin. For financial reports submitted to regulators, this traceability is often a compliance requirement. The footnote takes seconds to add and provides documentation that supports audit and review processes.
If you find yourself defining the same print areas repeatedly across multiple similar spreadsheets, standardize the layout. Use a template spreadsheet where the print areas are already defined and saved. When you create a new report, start from the template, populate the data in the predefined ranges, and export. The print areas are already configured. This template approach is standard practice in organizations that produce recurring reports with consistent structures.