Excel to PDF without losing formatting (2026 how-to)

You finish a spreadsheet, send it to PDF, and the layout falls apart. Columns spill onto a second page. The right edge gets cut. Gridlines vanish. A clean table on screen turns into three ragged pages in the PDF. This post is about how to convert Excel to PDF without losing formatting, and most of the real work happens in the spreadsheet before you ever upload it.

Here is the honest scope up front. docuconverter converts your .xlsx using a LibreOffice-based engine on the server. It does a good job on normal sheets. But a spreadsheet has no fixed page — it is a grid that can be any width. The converter has to decide where to cut that grid into pages, and on very wide or complex multi-tab files it can rescale text or break a table across pages in a way you did not intend. The fix for that is not a different converter. It is setting the print area and the scaling inside Excel first. I will show you how.

Why convert Excel to PDF at all

A few reasons come up again and again.

Sharing safely. A PDF opens the same way on every device. The reader does not need Excel, and cannot accidentally edit a cell or drag a formula.
Locking the layout. Once it is a PDF, the columns stay where you put them. What you see is what they see.
Printing. A PDF is print-ready. The page breaks are baked in, so the printout matches the preview.

If the other person needs to keep working in the numbers, send the .xlsx instead. PDF is for when the file is final, going to a portal that demands PDF, or headed to a printer.

Set the print area and page breaks first

This is the single biggest thing you can do. A spreadsheet is an open grid. If you do not tell it what to print, the converter guesses, and the guess is often "everything, at whatever scale fits". That is where blank pages and cut edges come from.

Do this in Excel before you save:

Select the cells you actually want. Highlight the real table — not the empty columns to the right that you scrolled past once.
Set the print area. Page Layout tab, then Print Area, then Set Print Area. Now only that block will convert.
Check the page breaks. View tab, then Page Break Preview. The blue lines show where pages will split. Drag them to a sensible spot so a table is not cut down the middle.
Use Print Titles for long tables. Page Layout, then Print Titles, then "Rows to repeat at top". This puts your header row on every page, so a long table stays readable after the first page break.

In Google Sheets the same idea lives under File, then Print, then "Selected cells" or a custom range, with the page break and scaling options on the right.

A short scope note: setting the print area in the source file is the real fix for layout problems. No converter can read your mind about which part of an open grid matters. Once you mark it, the conversion gets predictable.

How docuconverter handles xlsx

Once your print area is set, the conversion itself is simple. Go to convert Excel to PDF, upload the .xlsx, and download the result. No account is needed to upload, there is no watermark, and the file is deleted from the server about 30 minutes after you download it. Anonymous users get a couple of conversions a day before a sign-in prompt, and there is no credit card.

A few things worth knowing about what the engine does:

Formulas render as their computed values. The PDF shows 1,240, not =SUM(B2:B9). This is almost always what you want — but it means the PDF is a snapshot. If the numbers change later, you re-convert.
Each worksheet tab becomes its own set of pages. A workbook with five tabs produces a PDF that walks through all five in order. If you only need one tab, the cleanest path is to copy that tab into a fresh file and convert that.
It honors your print settings. The print area, the orientation, the scaling, the print titles — the engine reads them from the file. That is exactly why setting them first matters so much.

Here is what tends to convert cleanly versus what needs care.

Spreadsheet type	How it converts	What to do first
Single tab, normal width	Cleanly, page breaks as expected	Set print area
Long table, many rows	Cleanly across pages	Add print titles for the header row
Very wide, many columns	May rescale or cut the right edge	Fit to width, or go landscape
Many tabs, mixed layouts	Can break unevenly per tab	Set print area on each tab, or split the file
Heavy charts and images	Slower, charts flatten to image	Check the chart looks sharp in the output

Wide sheets and scaling

Wide sheets are the most common source of a bad Excel to PDF result. You have twenty columns, the page is one column wide, and the converter either shrinks everything to fit or chops the table in half.

There are three honest options, in order of preference.

Fit to one page wide. Page Layout, then the Scale to Fit group. Set "Width" to 1 page and leave "Height" at automatic. This tells the engine to shrink the columns just enough to fit the page width while letting the rows flow down as many pages as they need. This is usually the right answer for a wide report.

Switch to landscape. Page Layout, then Orientation, then Landscape. A landscape A4 page holds noticeably more columns before anything has to shrink. Often landscape alone solves a "cut right edge" problem without any scaling.

Accept the page break. If the sheet is genuinely huge — thirty columns of real data — squeezing it onto one page width makes the text too small to read. Let it break across pages, but control where with Page Break Preview so the break lands between logical column groups, not mid-table.

A warning worth saying plainly: "Fit to 1 page wide and 1 page tall" on a large sheet shrinks your text to the point of being unreadable. Fit the width, let the height run long. Readability beats a single page almost every time.

Gridlines and what shows up

People are often surprised that the faint grid they see in Excel does not appear in the PDF. By default, Excel screen gridlines are a viewing aid, not a print element. If you want lines in the PDF, you have two choices.

Turn on printed gridlines. Page Layout, then the Sheet Options group, then tick "Print" under Gridlines. Now the grid converts into the PDF. This is the quick option for a plain data dump.
Apply real cell borders. Select your table and add borders from the Home tab. Borders are part of the cell formatting, so they always convert, and they look cleaner than raw gridlines because you control which edges show. For anything you are sending to another person, borders look more finished.

The same applies to row and column headers (the 1, 2, 3 and A, B, C labels). They do not print unless you tick "Print" under Headings in Sheet Options. Most shared documents look better without them.

Verify before you send

Conversion is half the job. Take thirty seconds to check the output:

Count the pages. If you expected two and got five, something is breaking. Go back to Page Break Preview.
Look at the right edge. Is any column cut off? If so, fit to width or go landscape and re-convert.
Check the gridlines or borders. Are the lines you wanted actually there?
Read the numbers. Confirm the computed values look right and nothing rescaled into a blur.

If the PDF is right but the file is large because of charts or images, you can run it through compress PDF to bring the size down for email or a portal upload. And if you also work in Word documents, the same "fix the source first" idea applies when you convert Word to PDF.

The pattern holds across all of these: the converter renders what the source tells it to. A few minutes setting the print area, the scaling, and the gridlines in Excel will do more for your output than any tool switch. Set those, convert, and check the right edge. That is the whole trick.

Questions? email info@docuconverter.in

Sheo