Why did my Excel table split across several pages in the PDF?

Because an Excel worksheet is theoretically unlimited in width, while a PDF page has a fixed size. A table that looks continuous on screen gets divided into vertical strips when it doesn't fit the width of an A4 page, and each strip is placed on a separate page. This is not a bug but the natural consequence of a fixed page size. The fix is to adjust the page setup in Excel before converting: landscape orientation, reduced scaling, or the option to fit all columns onto one page width.

If I fit the whole table onto one page, will it still be readable?

Not always, and this is an important warning. The 'Fit all columns on one page' option fits the table by shrinking it; with a 40-column table that can mean the text becomes too small to read. It may look acceptable on screen at 100% zoom yet be unreadable in print. In that situation the better approach is to split the table into meaningful parts, hide unnecessary columns, or switch to landscape orientation.

Can I convert only a specific range of cells to PDF?

Yes, and Excel's 'Print Area' feature exists precisely for this. If you select the cell range you care about and set it as the print area from the Page Layout tab, only that region enters the output. This is very useful in files that hold calculation tables, helper columns or raw data sheets in the background. The print area is saved with the workbook, so the setting is respected when you convert the file.

Are formulas preserved in the PDF?

No, they are not — and in most cases that is the desired behaviour. A PDF shows the calculated result of a formula, that is the value visible in the cell; the formula itself does not enter the output. This is an advantage when sharing a financial report, since your calculation logic stays hidden. However, if the other party needs to work with the numbers or run scenarios, PDF is the wrong format and you should share the workbook itself.

Converting an Excel Spreadsheet to PDF: Fitting Pages and Scaling Issues

The fundamental mismatch between Excel and PDF

Almost every problem encountered when converting Excel to PDF stems from a single structural difference: an Excel worksheet has no page size, while a PDF does.

In Excel you can add as many columns to the right and as many rows downward as you like. The worksheet is an unlimited canvas that you navigate by scrolling. PDF, by contrast, is a format that imitates the printed page; everything has to be placed on a page of specific dimensions.

What happens during conversion is that this unlimited canvas gets divided into fixed-size pages. Excel performs that division according to its own rules, and if you don't configure those rules, the result is usually not what you expected: the table is cut in half, the last three columns land alone on the following page, the header row appears only on the first page.

This article explains what those rules are and how to configure them before converting.

How is the page division decided?

When Excel splits a worksheet into pages, it looks at width first. If the total width of the columns fits the page width (the area left after margins are deducted), there is no problem. If it doesn't fit, the columns that do fit go into the first vertical strip and the rest are pushed into the next one. The same operation is then performed vertically for rows.

The result is that a wide table is fragmented into a kind of grid: the top-left block on page one, the block to its right on page two, the block beneath the top-left on page three, and so on. This is well-known behaviour in printing, but it is confusing for someone opening the table as a PDF for the first time, because following a single row means flipping back and forth between pages.

You can see this behaviour in Excel before converting by switching to "Page Break Preview". Blue lines show where page breaks will occur, and you can drag those lines to decide the split points yourself. This is the most reliable way to predict the conversion result.

Orientation: portrait or landscape?

The default portrait orientation suits tables with few columns and many rows — a long two-column list, for example. But most business tables are the opposite: many columns and relatively few rows. In a monthly budget table, twelve months line up side by side as columns and will never fit a portrait page.

In such cases, switching to landscape orientation often solves the problem on its own. An A4 sheet in landscape offers roughly 40% more width than in portrait. That is usually enough for most medium-sized tables to fit within a single page width.

The orientation setting is made from the Page Layout tab in Excel and is saved with the workbook. So when you save the file and convert it, that preference is reflected in the output.

Scaling options and an honest warning

Excel's Page Setup contains several scaling-related options:

Normal size (100%). No shrinking is applied; the table prints at its true size and anything that doesn't fit spills onto other pages. Readability is at its highest, and so is the page count.

Shrink to a specific percentage. You supply a ratio such as 90% or 80%. It is a predictable option that leaves control with you.

Fit all columns on one page. The most commonly used and most misunderstood option. It shrinks the table's width until it fits the page width. It works perfectly when the column count is reasonable.

Here honesty is required: the fit-to-page option is not a magic solution. To make the table fit, Excel will if necessary shrink the font to an unreadable size, and it will not ask you first. Trying to fit a fifty-column data table onto one page produces a technically "successful" but practically useless PDF — readable when you zoom in on screen, unreadable when printed.

As a general rule, if the scale drops below 60% you need to change your approach. The options are: divide the table into logical sections and make each a separate page, hide intermediate calculation columns not needed in the report, or accept the situation and spread the table over multiple pages while preserving readability.

Settings that keep the output readable

A few small settings turn a multi-page table output into something usable.

Repeat header rows on every page. With the "Print Titles" setting inside Page Layout, you can make the first row (or first few rows) repeat at the top of every page. Without this setting, it becomes impossible to tell which column a number on the third page belongs to. On multi-page tables this is the single most valuable setting.

Turn on gridlines. The grey gridlines you see on screen in Excel are not included in the output by default. If you haven't drawn cell borders by hand, numbers appear to float in space in the PDF. Enabling gridline printing from Page Layout, or applying real borders to the table, noticeably improves readability.

Add page numbers and a date. Putting a page number in the header/footer area prevents multi-page outputs from getting out of order. Adding a date makes it easier to tell which version of a financial report you are looking at.

Exclude unnecessary sheets. If a workbook contains several sheets, not all of them need to enter the output. Selecting only the sheets you want to share, or defining a print area, prevents raw data tabs from accidentally going out.

Why share as PDF?

When you send a financial report, a proposal or a budget summary as an .xlsx file, you take on several risks. The other party may touch cells accidentally and change the numbers. They can see your formulas and therefore your calculation logic. Raw data may sit on a tab you forgot to hide — this is the classic route for information leakage in shared workbooks.

PDF closes all of these risks. The output is fixed, only the area you designated is visible, and results are shared instead of formulas. Converting the table with the Word/Excel/PPT → PDF tool also guarantees that the report looks the same for everyone; the recipient's Excel version or regional settings cannot alter the output.

By contrast, PDF is the wrong choice if the other party needs to work with the numbers. If a budget draft is going to be worked on jointly, sending the workbook is correct. The rule is simple: PDF if it will be reviewed, Excel if it will be worked on.

In summary

Nearly all the problems experienced when moving from Excel to PDF arise from fitting an unlimited worksheet onto a fixed page. Reviewing a few settings in Excel before converting — choosing the orientation to suit the table, keeping scaling within a limit that doesn't destroy readability, defining a print area and repeating the header row — is the real work that determines output quality. Rather than trusting the fit-to-page option blindly, seeing the result once in page break preview is the most practical habit.