How do I stop Excel cutting off the last column in the PDF?

Set Width to 1 page under Scale to Fit on the Page Layout tab, or use Fit All Columns on One Page in the print preview's Scaling menu. Excel to PDF has the same fit as a chip.

Why is the Scale box greyed out?

Because Width or Height is set to a page count. Excel computes the percentage itself. Set both back to Automatic to type a scale.

What is the smallest readable scale for a PDF?

Around 60 percent for an 11 point font. Below that, use landscape, narrow margins or A3 paper before shrinking further.

Can I fit a sheet on one page on a Mac?

Yes. The Scale to Fit group is on the Page Layout tab in Excel for Mac, and Page Setup has the same Fit to boxes. The browser tool works there too.

Does a bigger paper size change how the PDF looks on screen?

The page is larger and the text stays the same size. Readers zoom to fit the window, so an A3 page shows smaller than A4 at first but scales without any loss.

Fit an Excel sheet on one PDF page

Excel to PDF

How to fit an Excel sheet on one page in the PDF

Set the print area

Select the cells that belong on the page and choose Page Layout, Print Area, Set Print Area, so a stray cell far to the right does not join the scaling.
Open Scale to Fit

On the Page Layout tab set Width to 1 page and Height to 1 page. The Scale box greys out and shows the percentage Excel chose.
Read the percentage

Above 60 percent the sheet stays readable. Below 50 percent, switch to landscape or a larger paper size before going on.
Export and check

File, Export, Create PDF/XPS on Windows or File, Save As, PDF on a Mac. Open the PDF at 100 percent zoom and read the smallest cell.

What Excel is doing when it cuts a sheet off

Excel lays a page grid over the sheet using the paper size, the margins and 100 percent scale. Any column that crosses a grid line moves to the next page whole. A table 21 centimetres wide on A4 portrait paper with default margins loses its last column, and the PDF shows it on page two. This is what saving an Excel sheet as a PDF without cutting off is about: making the grid fit the table, or the table fit the grid.

The general export steps, including how to pick one sheet or the whole workbook, are in Convert Excel to PDF. This guide is only about the one-page problem.

Fitting the sheet in the browser tab

Excel to PDF reads the workbook here and offers the same choices as a row of chips: fit the columns to the page width, fit a sheet on one page, or leave the scale where the file put it. The first page is drawn at the current setting, and the line under it reports how many pages the workbook takes, so a fit that costs a dozen pages is visible before anything is written.

Paper and orientation sit beside the scale, which matters because the cheapest fix for a cut-off column is a wider page rather than a smaller font. The finished PDF is then reopened, every page is rendered, and the cell text is compared in order before the download appears, so a fit that lost a column is caught here rather than found by the reader.

Scale to Fit on Windows and Mac

The Page Layout tab has a Scale to Fit group with Width, Height and Scale. Setting Width to 1 page and Height to Automatic keeps every column on each page and lets the rows continue onto more pages. Setting both to 1 page puts the whole sheet on a single page. The same controls sit in Page Setup, Page, under Fit to, on both Windows and Mac.

The print preview under File, Print has a Scaling menu with three shortcuts: Fit Sheet on One Page, Fit All Columns on One Page and Fit All Rows on One Page. They set the same options and redraw the preview at once, which makes them the quickest way to see whether the result is readable.

When the text gets too small

Scaling shrinks everything by the same factor. At 50 percent an 11 point font prints at 5.5 points, smaller than the small print on a mobile phone contract, and a PDF reader shows it at that size until the reader zooms. A sheet that needs 35 percent to fit is not a one-page sheet. Two readable pages beat one that has to be zoomed into in four quarters.

The Scale box shows the percentage Excel picked. Treat 60 percent as the floor for a document other people will read, and 75 percent for one that will be printed.

Landscape, margins and a bigger page

Before shrinking, make the page bigger. Landscape orientation gives a table 40 percent more width on the same paper, and Excel to PDF in landscape has the setting. Narrow margins, from Page Layout, Margins, add another two centimetres. And because a PDF has no physical paper, Page Setup, Paper size, A3 doubles the page area while the text stays at 100 percent; the reader zooms out or scrolls, and every cell is still 11 point.

Combine the three and most tables fit at 100 percent with nothing shrunk. Save the scaling for the last five percent.

Fit the columns, let the rows run

A 600-row list is not meant for one page. Set Width to 1 page and Height to Automatic, then turn on Page Layout, Print Titles, Rows to repeat at top, and choose the header row. Every page of the PDF then shows the column names, and the reader never has to scroll back to see what a number means.

A footer with Page &[Page] of &[Pages] from Page Setup, Header/Footer tells the reader how long the document is, which a one-page-at-a-time PDF view does not.

Checking the result

Open the PDF and go to the last page first. That is where the orphan column or the single row lands when the fit is wrong. Then zoom to 100 percent and read the smallest text. If the layout moved in ways the preview did not show, Excel to PDF without losing formatting lists the settings that shift a layout.

Whichever route wrote the file, the last page and the smallest cell are the two things to look at. The rest of the spreadsheet guides sit under PDF, Word and Excel help.

Questions people ask

How do I stop Excel cutting off the last column in the PDF?: Set Width to 1 page under Scale to Fit on the Page Layout tab, or use Fit All Columns on One Page in the print preview's Scaling menu. Excel to PDF has the same fit as a chip.
Why is the Scale box greyed out?: Because Width or Height is set to a page count. Excel computes the percentage itself. Set both back to Automatic to type a scale.
What is the smallest readable scale for a PDF?: Around 60 percent for an 11 point font. Below that, use landscape, narrow margins or A3 paper before shrinking further.
Can I fit a sheet on one page on a Mac?: Yes. The Scale to Fit group is on the Page Layout tab in Excel for Mac, and Page Setup has the same Fit to boxes. The browser tool works there too.
Does a bigger paper size change how the PDF looks on screen?: The page is larger and the text stays the same size. Readers zoom to fit the window, so an A3 page shows smaller than A4 at first but scales without any loss.

Do it now

The tool runs in this browser. Your file never leaves the machine, and the result is checked before you download it.