How to convert Excel to PDF (without cutting off columns)
Excel spreadsheets and PDFs are fundamentally incompatible, and everyone pretends they aren't.
Excel is fluid. Columns resize. Rows expand. The view scrolls horizontally. You can have 50 columns and see them all by scrolling right. The data lives in a boundless grid.
PDF is fixed. It has pages. Pages have edges. Everything needs to fit within those edges. When your 50-column spreadsheet meets a PDF's page width, something has to give. Usually, it's columns 8 through 50, which simply disappear off the right side of the page.
This is why people dread the "can you send that as a PDF?" request. Because it's never as simple as clicking Export.
Quick answer
Open the Excel to PDF tool at filesflow.net
Upload your .xlsx file
Adjust page orientation and sizing options if available
Click Convert
Download the PDF
For wide spreadsheets, use landscape orientation and adjust column widths or scaling before converting.
Why Excel-to-PDF conversion is tricky
The core problem is dimensional.
A standard Letter-size page in portrait orientation is 8.5 inches wide. At typical print margins, your usable width is about 7 inches. A standard column in Excel is roughly 0.9 inches wide. That gives you room for about 7-8 columns before content starts getting cut off.
Most real spreadsheets have more than 8 columns.
Landscape orientation buys you more width (about 9.5 inches usable), which gets you to maybe 10-11 columns. Better, but still not enough for many spreadsheets.
The solutions are: narrower columns, smaller font, multi-page layouts with column breaks, or accepting that some data will wrap or be split across pages.
Full step-by-step guide
Step 1: Prepare your spreadsheet
This is where most people skip ahead and regret it. A few minutes of preparation saves a lot of frustration.
Decide what data matters. Do you need all 30 columns in the PDF, or just 12? Hide the columns you don't need. Right-click the column header, click Hide. This is the single most effective way to get a clean PDF.
Adjust column widths. Some columns are wider than they need to be. If a column header says "Revenue" but the column is wide enough for "Quarterly Revenue Generated from Digital Marketing Campaigns," narrow it down. Double-click the column border to auto-fit width to the content.
Choose your fonts wisely. Smaller fonts (9pt or 10pt instead of 11pt) make a significant difference in how many columns fit on a page. This sounds obvious, but most people leave the default 11pt Calibri and wonder why nothing fits.
Set the print area. In Excel, select the cells you want to convert, then go to Page Layout > Print Area > Set Print Area. This tells the converter exactly which data to include, ignoring empty rows and columns outside the selection.
Step 2: Upload to FilesFlow
Go to filesflow.net and open the Excel to PDF tool. Upload your .xlsx file.
Step 3: Conversion settings
If the tool offers settings, pay attention to:
Page orientation: Choose landscape for wide spreadsheets (more columns fit), portrait for tall spreadsheets with few columns.
Page size: A4 and Letter are the most common. A3 is double the width of A4 and fits significantly more columns, but it's harder to print on standard printers.
Scaling: "Fit all columns on one page" forces the spreadsheet to shrink until everything fits within the page width. The trade-off is smaller text. For spreadsheets with 15-20 columns, this produces readable results. For 40+ columns, the text becomes microscopic.
Step 4: Convert and download
Click Convert. Download the PDF. Open it and check:
Are all the columns visible?
Is the text readable?
Are row heights correct?
Did any data get truncated (shown as ### or cut off)?
Step 5: Iterate if needed
If the first attempt doesn't look right, go back to Step 1 and adjust. Hide more columns, reduce font size, switch to landscape, or change the scaling. It often takes 2-3 tries to get a wide spreadsheet to fit nicely.
Formatting tips for better PDFs
Freeze panes and print titles
In Excel, you can set rows to repeat at the top of every page (Page Layout > Print Titles). This means your column headers appear on every page of the PDF, not just the first one. Without this, page 2 onward is just numbers with no labels. Nobody knows what column C represents when the headers are only on page 1.
Gridlines
By default, Excel's gridlines don't always export to PDF. If you want visible cell borders in the PDF, add actual borders (Home > Borders) rather than relying on gridlines. Or check the Page Layout > Sheet Options > Gridlines > Print checkbox.
Page breaks
Excel lets you manually set page breaks (Page Layout > Breaks > Insert Page Break). This gives you control over where data splits across pages. Without manual breaks, Excel's auto-breaking might split a table in an awkward place, like right in the middle of a grouped data section.
Header and footer
Add page numbers, the file name, or the date through Page Layout > Header/Footer. This is especially useful for multi-page PDFs so readers know which page they're looking at and when the data was generated.
Common issues and fixes
Columns are cut off on the right side. The spreadsheet is too wide for the page. Switch to landscape orientation. If that's still not enough, reduce font size, narrow columns, or hide unnecessary columns. As a last resort, use "fit all columns on one page" scaling.
Text is too small to read. You used aggressive scaling to fit everything on one page. There's a limit to how much you can shrink text before it becomes unreadable. Consider splitting the data across multiple pages instead, or removing columns that aren't essential.
Cells show ### instead of data. The column is too narrow to display the content. Widen the column in Excel before converting, or use auto-fit (double-click the column border).
Merged cells look wrong. Merged cells in Excel sometimes don't convert cleanly to PDF. If possible, unmerge cells and use center-across-selection or indent formatting instead.
Charts didn't come through. Some online converters handle data well but struggle with embedded charts. If charts are critical, try converting through Excel's own PDF export (File > Export > Create PDF) for better chart rendering. Or export the chart as an image separately.
Colors and conditional formatting are missing. Basic cell colors usually convert fine. Complex conditional formatting (color scales, icon sets, data bars) might not survive the conversion. If these visual elements are important, take a screenshot of the formatted view and insert it as an image.
The PDF has too many blank pages. The print area might include empty cells below or to the right of your data. Set the print area explicitly to just the data range to avoid extra blank pages.
Excel's built-in PDF export vs. online tools
Excel itself can export to PDF (File > Export > Create PDF/XPS on Windows, or File > Save As > PDF on Mac). This usually produces the best results because Excel has complete access to its own formatting engine, fonts, and layout system.
Use an online tool when:
You don't have Excel installed
You received the file on a phone or Chromebook
You need to convert multiple files quickly
Excel's export is producing unexpected results and you want a second option
Excel's export and an online tool might produce slightly different results from the same file. If one looks wrong, try the other.
Dealing with really wide spreadsheets
Some spreadsheets are just too wide for any reasonable PDF format. A financial model with 40 columns and monthly data for 3 years is going to be painful no matter what tool you use.
For these cases, consider alternatives:
Split into sections. Convert columns 1-15 as one PDF and columns 16-30 as another. Label them clearly.
Transpose the data. If the spreadsheet is wide because of time periods across the top (Jan, Feb, Mar, etc.), transposing puts time periods in rows instead. The resulting PDF is tall instead of wide, which fits pages much better.
Create a summary view. Instead of converting the raw data spreadsheet, create a summary tab with the key figures and convert that. The full data stays in Excel for anyone who needs it.
Use a different format. If the recipient needs to see all the data, sending the Excel file might be better than forcing it into PDF. PDF is great for fixed-layout documents but terrible for wide data tables.
FAQ
Can I convert Excel to PDF on my phone?
Yes. FilesFlow works in mobile browsers. Upload your .xlsx file, convert, and download the PDF.
Will my formulas show in the PDF?
PDFs show cell values, not formulas. Whatever is displayed in the cell (the calculated result, not the formula) is what appears in the PDF. This is usually what you want.
Can I convert .xls (old format) files?
Most converters handle .xlsx (modern format) best. If you have an old .xls file, open it in Excel or Google Sheets, save as .xlsx, then convert.
Is it free?
Yes. No fees, no limits.
Are my files safe?
FilesFlow processes files in your browser. Your spreadsheet never leaves your device.
Can I convert multiple sheets at once?
Depends on the tool. Some converters process all sheets in a workbook, creating a multi-page PDF. Others only convert the active sheet. If you need all sheets, check whether the tool supports multi-sheet conversion.
Why does my PDF look different from Excel?
PDFs use fixed page dimensions. Columns that scroll freely in Excel need to fit within page edges in PDF. Differences in font rendering between Excel and the PDF converter can also cause minor layout shifts.
The honest truth
Excel to PDF is never going to be seamless for complex spreadsheets. The formats are designed for different purposes. But with some preparation (hiding unnecessary columns, adjusting widths, choosing the right orientation) and a decent conversion tool, you can get a PDF that's clean and readable. Just accept that it might take a couple of tries for wide datasets.
Tags
- excel
- convert