How to Convert Excel to PDF
and Keep the Layout

How to Convert Excel to PDF

Excel for Windows

1. Set orientation and scaling first (Page Layout tab), then choose File → Save As and pick PDF.
2. Click Options and choose Active sheet(s), Entire workbook or Selection.
3. Click Save. File → Export → Create PDF/XPS does the same.

Excel for Mac

Choose File → Save As, set File Format to PDF, pick Workbook or Sheet, and save.

Google Sheets

Choose File → Download → PDF. The export settings let you pick the current sheet or the whole workbook, orientation and Fit to width.

Online (this page)

Upload an XLSX, XLS, ODS or CSV file and download the PDF. LibreOffice uses the page settings stored in the file, so set them in Excel first.

The Main Challenges

Excel to PDF conversion faces unique challenges that other document conversions do not:

• Infinite canvas vs fixed page: Spreadsheets can be thousands of rows long and dozens of columns wide. A PDF page has fixed dimensions. The converter must decide where to break the content.
• Column width: Wide spreadsheets with many columns often do not fit on a single page, even in landscape orientation. Columns get cut off or split across pages.
• Dynamic content: Formulas, conditional formatting, data validation, and dropdown lists are interactive Excel features that become static in PDF. If you need the raw data rather than a printable page, see how to convert XLSX to CSV.
• Multi-sheet workbooks: Workbooks with multiple sheets need clear separation in the PDF output.

Page Setup for Clean PDFs

The single most important step for a clean Excel to PDF conversion is proper page setup before converting:

Orientation

Choose landscape for wide spreadsheets (more columns than rows) and portrait for tall spreadsheets (more rows than columns). In Excel: Page Layout → Orientation.

Margins

Default margins are generous (0.75 inches on each side). For data-heavy spreadsheets, switch to Narrow margins (0.25 inches) to gain significant usable space. In Excel: Page Layout → Margins → Narrow.

Scaling / Fit to Page

Excel's scaling options are the most powerful tool for controlling PDF output:

Setting Print Areas

If you only need a portion of your spreadsheet in the PDF, set a print area:

• Select the range of cells you want to include
• Go to Page Layout → Print Area → Set Print Area
• Only the selected area will appear in the PDF

This is particularly useful for large spreadsheets where only a specific table or summary section needs to be shared as a PDF. You can set multiple print areas on the same sheet — each area prints on a separate page.

Handling Multiple Sheets

Workbooks with multiple sheets are converted with each sheet starting on a new page in the PDF. Key considerations:

• Visible sheets only: Hidden sheets are excluded from the PDF. Use this to control which sheets are included without deleting data.
• Sheet order: Sheets appear in the PDF in the same order as the tab bar in Excel. Rearrange tabs before converting if needed.
• Individual page setup: Each sheet can have its own page setup (orientation, margins, scaling). Configure each sheet independently for the best result. To share a single sheet from the finished PDF, our extract PDF pages tool saves just its pages as a new file.
• Headers and footers: Set consistent headers/footers across all sheets for a professional multi-page PDF. Include sheet name using the &A code for automatic sheet name insertion.

Charts and Conditional Formatting

Charts and Graphs

Excel charts are rendered as high-quality static graphics in the PDF. The visual appearance is preserved faithfully — colors, labels, gridlines, and legends all appear correctly. However, they become non-interactive: no hovering for data points, no resizing, and no data series editing.

Charts embedded within a sheet are printed where they are positioned. Chart sheets (a sheet containing only a chart) become full-page charts in the PDF, which often look more professional than embedded charts.

Conditional Formatting

Conditional formatting (data bars, color scales, icon sets, highlighted cells) is preserved in the PDF. The current state of all conditional rules is captured at conversion time. However, since PDF is static, the formatting will not update if the underlying data changes. If someone later needs the numbers back out of the PDF, see how to convert PDF to CSV.

Formulas

The PDF shows cell values, not formulas. If you have accidentally left your spreadsheet in “Show Formulas” mode (Ctrl+`), the PDF will show formulas instead of calculated values. Make sure to switch back to normal view before converting.

Headers, Footers, and Page Breaks

Repeating Headers

For multi-page spreadsheets, configure “Rows to repeat at top” so that column headers appear on every page. In Excel: Page Layout → Print Titles → Rows to repeat at top. Select the row(s) containing your column headers.

Page Breaks

Excel automatically inserts page breaks based on your page setup. Preview them using View → Page Break Preview. You can manually drag page breaks or insert them at specific rows/columns. For the cleanest PDF output:

• Insert page breaks at logical data boundaries (between sections, after subtotals)
• Avoid breaking in the middle of a data group
• Use the blue dashed lines in Page Break Preview to see exactly where pages will split

Headers and Footers

Add professional headers and footers via Insert → Header & Footer. Common elements include:

• Document title and date
• Page numbers (Page &P of &N)
• Sheet name (&A)
• File path for document tracking
• Company logo (as a small image)