How to Convert Excel to PDF Without Cutting Off Columns

October 17, 2026 • NOFYI Editorial Team

A spreadsheet that looks complete on screen can lose its right-hand columns when it becomes a PDF. The last columns may disappear, split across pages, or shrink so much that the numbers are hard to read. This is one of the most common Excel-to-PDF problems, and it is usually caused by page setup, not by a broken file.

Excel is designed for working with data on a grid that can scroll in both directions. A PDF is designed for fixed pages. When you convert, Excel must decide how that wide grid fits onto pages of a set width. If you do not set that fit before converting, the software makes a choice for you, and the choice is often to cut the sheet at the page edge. This guide explains how to fit a sheet to the page, shows a worked example, and covers what does not carry over into a PDF.

The core idea is simple: check the print preview before you convert. Print preview shows you exactly where pages break, which columns will appear on each page, and whether headings will repeat. If the preview looks wrong, the PDF will look wrong too. Fix the preview, and the PDF usually follows.

Why Columns Get Cut Off

Columns are cut off when the total width of the columns you want to print is wider than the printable width of the page. Printable width is the page width minus the left and right margins. A sheet with ten wide columns, for example, may be far wider than a portrait A4 or Letter page. Excel will then print the first columns on page one, the next columns on page two, or it may simply stop at the page edge, depending on the settings.

Other factors make the problem worse. Long text in a cell can be hidden by the next cell, even though it looks complete in the normal view. Wide date formats, currency symbols, and long headings can push a column wider than expected. Merged cells, charts, and images placed near the right edge can also extend the print area. Hidden columns do not print, but very narrow columns, filters, and print titles can change how the page breaks fall.

The first step, therefore, is not to convert. It is to look at the sheet as a printed page. Open print preview, check the number of pages, and look at the last column on each page. If a column is missing, split, or squeezed, you have found the problem before anyone else sees it.

How to Convert Excel to PDF Without Cutting Off Columns

The steps below use the page setup and print controls found in most spreadsheet programs. The names of the menus may differ slightly, but the ideas are the same.

Keep the original XLSX file. Save a copy before you change page setup. Page setup changes are useful for printing, but they can change how the sheet looks on screen. Keep the original so you can return to it.
Set the print area. Select only the cells you want in the PDF, and set them as the print area. This prevents distant notes, old drafts, or stray values from adding extra pages.
Choose the page orientation. Wide sheets usually work better in landscape. A landscape page gives you more width and fewer split columns. If the sheet is tall and narrow, portrait may be better.
Fit to page width. In page setup, set the sheet to fit to one page wide, and to as many pages tall as needed. This is the setting that most often fixes cut-off columns. Avoid fitting to one page tall as well unless the sheet is short, because that can shrink everything to an unreadable size.
Adjust margins and scaling. Narrow margins give you a little more printable width. If the sheet still does not fit, reduce the scale in small steps, such as from 100 percent to 90 percent, rather than jumping to a tiny size. Check readability after each change.
Check print preview. Look at every page, especially the first and last pages. Confirm that all columns appear, that headings are not cut in half, and that no blank pages appear at the end.
Convert to PDF. Only after the preview is correct, export or print to PDF. Save the PDF with a clear name, such as monthly-report.pdf, and keep the XLSX file alongside it.

If the sheet is too wide even in landscape at a readable scale, do not force it onto one page. It is better to let it flow across two pages with clear repeated headings than to produce one tiny, unreadable page. Readers can follow a two-page table if the headings repeat. They cannot read text that has been shrunk to a few points.

Worked Example: A Monthly Sales Sheet

Imagine a monthly sales sheet with nine columns: Region, Salesperson, Product, Units, Unit Price, Discount, Net Sales, Date, and Notes. There are 40 rows of data. In the normal view, all nine columns are visible. The goal is a PDF that shows all nine columns on each page, with the headings repeated, so a manager can read it without turning the page sideways and guessing.

The first export is made without changing page setup. The PDF shows only the first six columns. Region, Salesperson, Product, Units, Unit Price, and Discount appear, but Net Sales, Date, and Notes are missing from page one. They appear on a second, mostly empty page, separated from the rows they belong to. The numbers are hard to match to the right region, and the PDF is not usable.

The fix starts with the original XLSX file. The print area is set to the nine columns and 40 rows, plus the heading row. The orientation is changed to landscape. In page setup, the sheet is set to fit to one page wide and zero pages tall, which means as many pages tall as needed. The margins are set to narrow, and the scale is checked at 95 percent. The heading row is set to repeat at the top of each printed page.

Print preview now shows two pages. Page one holds the first 25 rows with all nine columns. Page two holds the remaining rows, also with all nine columns, and the heading row repeats. The Notes column is a little narrow, so its longest entries wrap onto two lines, but no text is cut off. The PDF is exported again and checked page by page. Every column is present, every row matches the XLSX file, and the headings are clear on both pages. The original XLSX file is kept, because the PDF cannot be used to recalculate totals or correct a value.

Fit to Page: What It Does and What It Does Not Do

Fit to page width tells the spreadsheet program to scale the sheet so that the print area fits within the width of one page. It does not change the data, the formulas, or the column widths in the XLSX file. It changes how the sheet is rendered for printing and for PDF export.

Fit to page can, however, make text smaller. If a sheet is very wide, the program may shrink it so much that the PDF is hard to read on paper or on a phone. That is a signal that the sheet needs a different solution, not a smaller scale. Consider removing a column, shortening headings, moving notes to a separate sheet, or splitting the sheet into two tables. A PDF that is technically complete but unreadable is not a good result.

Fit to page also interacts with page breaks. Manual page breaks can force a sheet to split in a place that cuts a column or a row. If you have set manual breaks in the past, check them in print preview and remove any that no longer make sense. Automatic breaks are usually easier to manage when the goal is a clean PDF.

Problem	Likely Cause	Fix to Try
Last columns missing	Sheet wider than printable page	Landscape, fit to one page wide, narrow margins
Columns split across pages	No fit-to-width setting	Fit to one page wide, check preview
Text too small to read	Sheet forced onto too few pages	Allow more pages, shorten headings, split table
Blank pages at the end	Print area includes empty cells	Reset print area to data only
Headings only on first page	No repeated rows set	Repeat heading row on each page
Rows cut in half	Page break through a row	Adjust page breaks and row heights

Check the Print Preview Carefully

Print preview is the most useful check in this process. Do not rely on the normal sheet view. A cell that looks complete on screen may be truncated on the page, and a column that looks narrow may be wider in print.

Check the first and last pages. The first page often looks fine while the last page reveals a missing column or a blank page.
Check the right edge. Look at the last column on each page. If its border or text is cut, the sheet is still too wide.
Check headings. Confirm that the heading row repeats on every page and that no heading is split.
Check totals. Confirm that total rows appear once, at the end, and that they are not split across pages.
Check numbers. Look for cells that show hash symbols, which can mean a column is too narrow to display the value. Widen the column or shorten the number format.
Check charts and images. Confirm that they are not covering data, and that they do not push the print area wider.

If you find a problem in preview, fix it in the XLSX file and preview again. Do not try to fix it in the PDF. A PDF is a finished output. The XLSX file is where layout, data, and formulas live.

Freeze Panes Do Not Carry Over

Freeze panes is a screen feature. It keeps a row or column visible while you scroll through a sheet. It does not affect printing, and it does not carry over into a PDF. A reader of the PDF cannot scroll, so frozen panes cannot help them.

To give PDF readers the same benefit, use the print title settings instead. Set the heading row to repeat at the top of each page, and, if the table is split across pages, set the first column to repeat at the left of each page. That way, every page of the PDF carries the labels the reader needs, without relying on a screen feature.

The same principle applies to filters, comments, and hidden rows. Filters may hide rows in the sheet, but the PDF will show whatever rows are visible in the print settings. Comments may appear as small markers or not at all, depending on the export settings. Hidden rows and columns do not print, but they can still affect the print area if they are included in it. Check the preview to see what will actually be included.

Keep the Original XLSX File

A PDF is a snapshot. It preserves how the sheet looked at one moment, but it does not preserve formulas, data validation, or the ability to sort and filter. If a value changes, you cannot simply edit the PDF and expect the totals to update. You must edit the XLSX file and export a new PDF.

Keep the original XLSX file with a clear name, such as monthly-report.xlsx, and keep the PDF beside it with a matching name. If you send the PDF to someone else, keep the XLSX file for yourself, so you can answer questions, correct errors, and produce a revised PDF. If the PDF is the only copy, a small correction can become a long rebuild.

Frequently Asked Questions

Why does my Excel PDF cut off the last columns?

The sheet is wider than the printable width of the page. Use landscape orientation, set the sheet to fit to one page wide, use narrow margins, and check print preview. If the sheet is still too wide, shorten headings or split the table rather than shrinking it until it is unreadable.

Should I fit the sheet to one page wide and one page tall?

Usually not, unless the sheet is short. Fitting to one page tall can shrink a long sheet to a tiny size. Fit to one page wide and as many pages tall as needed, so the text stays readable and the rows flow naturally.

Do freeze panes work in a PDF?

No. Freeze panes only affect scrolling on screen. For a PDF, use print titles to repeat the heading row on each page, so readers can see the labels on every page.

Why are there blank pages in my PDF?

The print area often includes empty cells, stray formatting, or an image far from the data. Reset the print area to the data you want, check for objects outside the data, and preview again before exporting.

Converting Excel to PDF works best when you treat print preview as the real test. Set the print area, fit to one page wide, repeat the headings, and check every page. Keep the original XLSX file, because the PDF is a snapshot, not a working spreadsheet. When the preview is correct, the PDF will usually be correct too.