How to save Excel as PDF without cutting off the table

In a copy of the workbook, set the print area, orientation and print titles, delete extra sheets and save it as XLSX. Keep "Fit sheets to width" on and find the last column in the PDF. Charts and XLS files skip fitting, so set the scale in Excel.

A wide spreadsheet usually breaks in a PDF in one of two ways: the right-hand columns spill onto separate pages, or the text shrinks until the figures are unreadable. The Excel to PDF converter can fit sheets to the page width, but that fitting does not run for every file. Below is what the tool actually does, what to set up in Excel beforehand, and how to tell from the finished PDF what went wrong.

The short version: prepare a copy of the workbook, check the converter's two settings, then open the PDF and look for the last column of the table.

What the converter does with your workbook

The tool page accepts one XLSX or XLS file. Every sheet in the workbook goes into the PDF: the converter has no option to pick individual sheets, so anything you do not want to send has to be removed from the file first.

The "Parameters" block has two switches:

• "Fit sheets to width" is on by default. For an XLSX file it sets each sheet to "1 page wide", with no limit on the number of pages down. If a sheet has no orientation of its own, fitting switches it to landscape; an orientation you chose explicitly in Excel, portrait included, is kept. The sheet's own scaling is replaced: if you already set, say, 70% or "1 page wide by 1 tall" in Excel, turn this setting off or your scaling will be overwritten.
• "Print grid lines" is off by default. When on, it prints grid lines on every sheet. Turning it off does not remove anything: cell borders stay, and if gridline printing is already enabled in the workbook itself, the lines still appear.

Prepare a copy of the workbook in Excel

Work on a copy, not the live file. Delete working sheets, scratch calculations and hidden tabs with data the recipient should not get. Check that formulas show current values, then save.

Next, limit what gets printed. Select the range you need, header included, and choose Page Layout → Print Area → Set Print Area. Notes to the right of the table, or empty but formatted cells far below it, then stay out of the PDF instead of producing blank pages.

View → Page Break Preview is a handy way to see the pagination: the blue lines show where Excel splits the sheet into pages. A boundary running through the middle of the table is the first suspect for a cut-off column.

Orientation, header rows and scaling in Excel

Three sheet settings have the biggest effect on the result.

1. Page Layout → Orientation. Tables with a dozen columns usually go landscape; a narrow register can stay portrait. The converter does not change an orientation you set explicitly. 2. Page Layout → Print Titles. On the Sheet tab, enter the header row in "Rows to repeat at top", for example `$1:$1`. Column headings then repeat on every PDF page, so a long table can be read from any point. 3. Page Setup → Scaling. Choose "Fit to: 1 page wide" and leave the "tall" box empty. This is the same logic as "Fit sheets to width", only stored in the workbook itself. You need it when the converter's fitting does not run (covered in the next section).

If there are too many columns, fitting will squeeze them into the width, but the font gets small. In that case it is better to drop secondary fields or split the report into two logical parts than to force everything onto one page.

When fitting is skipped: charts, pivot tables and XLS

Charts and pivot tables. If any sheet in the workbook contains a chart or a pivot table, the converter always skips layout preparation for the whole workbook, because re-saving could damage those objects. Both settings are affected: neither fitting nor grid lines are applied, and the PDF follows each sheet's own print settings. The result shows a warning about this.

What to do:

• set the scaling in Excel itself with "Page Setup → Fit to 1 page wide"; that setting survives because the file is converted as-is;
• or make two copies of the workbook: the tables without charts (fitting will work there) and a separate file with the charts. You can then join the PDFs, as explained in how to merge several PDFs into one file.

Legacy XLS format. For XLS files both settings are ignored and the workbook is converted as-is. With the default settings you do not even get a warning; fitting simply does not happen. A warning appears only if you turned fitting off or grid lines on. The tool page also notes below the settings that legacy formats are converted via LibreOffice and formatting may vary slightly. The fix is simple: **File → Save As → Excel Workbook (*.xlsx)**, then upload the XLSX.

Step by step: from upload to finished PDF

1. Open Excel to PDF and drag the prepared copy into the upload area or choose it on your device. 2. In the "Parameters" block, fill in "Output file name" if you want a specific name. 3. Leave "Fit sheets to width" on. Turn it off only if the scaling is already set carefully in Excel. 4. Turn on "Print grid lines" if the table has no borders and rows blur together without lines. 5. Click "Process file", wait for it to finish and download the PDF. 6. Read any warnings attached to the result: they tell you whether fitting was skipped.

How to check the PDF and spot common mistakes

Take a report with 12 columns where the rightmost one is called "Balance". In the PDF, its heading and values should sit on the same page as the first column. Open the first, a middle and the last page at normal reading size, not zoomed out.

Typical symptoms and their causes:

• Narrow strips with the "Balance" column on separate pages. Fitting was not applied: the workbook is XLS, it contains charts or pivot tables, or the setting was off. Set the scaling in Excel or remove the cause.
• All columns are there, but the figures are unreadable. There are too many columns for one page width. Drop fields, split the report, or switch to landscape if the sheet was portrait.
• The header appears only on the first page. "Rows to repeat at top" is not set in Print Titles.
• Blank pages or stray blocks. No print area is set, or extra sheets are still in the workbook; all of them go into the PDF.
• Unwanted grid lines. Gridline printing is enabled in the workbook; clear Page Layout → Sheet Options → Gridlines → Print.

If the document then has to be uploaded to a portal with a size limit, check the file size too: how to prepare a PDF for upload covers the usual requirements for such files.