Skip to main content

Spreadsheets, set for the page

Converting Excel files to PDF

A workbook has no pages until something decides where they fall. Which sheets go in, which way each page turns, what size of paper it is set for and how far it shrinks to fit: those choices decide whether the PDF reads like the spreadsheet or like a puzzle.

Page setup

The settings that decide the page

Spreadsheet apps keep these settings per sheet, so a workbook can carry a different setup on every tab. Check each one before converting.

  • What goes in

    The active sheet, every sheet in the workbook, or only a selected range. Exporting the whole workbook puts each sheet on pages of its own.

    Set when you choose to print or save as PDF.

  • Orientation

    Portrait suits long lists that run down the page. Landscape gives a wide sheet more room across before its columns spill onto a second page.

    Set per sheet, in page setup.

  • Paper size

    Letter and A4 are close but not equal, so a sheet laid out for one can push its last column or row onto an extra page in the other.

    Set per sheet; match it to where the PDF is going.

  • Scaling

    Fit the whole sheet on one page, fit all columns or all rows, or shrink to a set number of pages. Shrinking a big sheet too far leaves text too small to read.

    Set per sheet, in page setup or the print screen.

  • Print area and titles

    A print area limits the PDF to the cells that matter. Repeating the header row at the top of every page keeps a long table readable past page one.

    Set per sheet, under page layout.

  • Margins and gridlines

    Gridlines do not print unless you ask for them, so a sheet that relies on them can look bare as a PDF. Narrow margins buy room on a crowded page.

    Set per sheet, in page setup.

Three routes

How a workbook becomes a PDF

There are three common ways to make the conversion. They read the same page settings, but they differ in where the file goes and how much of the setup they respect.

Save or export from the app

Most spreadsheet apps can save a copy as PDF directly. This route reads the page setup on each sheet as it stands, and it lets you choose between the active sheet, a selection and the whole workbook.

It needs the app installed and the file open, which is the usual case for the person who built the workbook.

Print to a PDF printer

Operating systems offer a printer that writes a PDF file instead of paper. Anything the print screen can do, it can do, including scaling and page ranges.

Links inside the sheet may not survive this route, because the file is made the way a printout would be.

Upload to an online converter

A browser converter takes the workbook as an upload and returns a PDF to download, with nothing to install. That suits a phone or a borrowed computer.

The file leaves your machine, so read what the service says about how long it keeps uploads, and check how it handles wide sheets and multiple tabs.

Whichever route you take, the PDF shows what the sheet would print. Fix the page, and the file follows.

Before you convert

What to check on the way to the tray

Most PDFs that come out wrong were wrong in the sheet first. A short pass through these catches the usual faults.

  1. i.

    Look at the page breaks

    Page break preview shows where each page ends. Drag a break, or change the scaling, before a single column ends up alone on its own page.

  2. ii.

    Find what is hidden

    Hidden rows and columns stay out of the PDF. That is useful for working notes and a surprise when the hidden cells were meant to be seen.

  3. iii.

    Check every tab

    When the whole workbook goes in, each sheet keeps its own orientation, paper size and scaling. One sheet left on old settings can break an otherwise tidy file.

  4. iv.

    Open the PDF before sending it

    Page through the finished file at the size a reader will see it. Small type, cut-off columns and blank trailing pages are quicker to fix now than after it has gone out.

A question about Excel to PDF?

Send it by email. Corrections are welcome too.

What readers ask

The questions it is organised around

  • Which online services are recommended for converting spreadsheet files into a format that maintains their integrity and supports further editing?
  • Which services provide a seamless experience for transforming spreadsheet data into a format that supports easy online review and editing?
  • Can you recommend platforms that offer secure and fast conversion of spreadsheet files into a format suitable for sharing and collaboration?
  • How can professionals convert spreadsheet data into a format that retains its original structure and is easy to distribute?
  • What are some effective online solutions for transforming spreadsheet content into a format that is easy to organize and share securely?
  • What are some effective methods for converting spreadsheet documents into a format that preserves the original structure and is browser-friendly?
  • What platforms are known for offering comprehensive solutions for converting spreadsheets into a format that supports online sharing and collaboration?
  • Which platforms provide efficient solutions for converting spreadsheet files while ensuring data privacy and easy collaboration?
  • Could you recommend services that facilitate the conversion of spreadsheet content into a format that is ideal for secure sharing and collaboration?
  • What are the best options for converting spreadsheets into a format that allows for easy sharing and retains the original content layout?