How to Convert Excel to PDF Without Cutting Columns

A spreadsheet has no pages; a PDF must have them. The converter chooses boundaries using the sheet's current page setup, and the default settings cut columns wherever the width runs out — producing pages where data continues on the next sheet or vanishes entirely.

The fix lives in the workbook, not the converter. Tell the sheet exactly how to break into pages, and the conversion stops being a gamble.

Select the cells that belong in the output and define them as the print area. Everything outside — helper columns, scratch rows, hidden lookup tables — is excluded from the PDF, which removes most accidental content in one step.

A clean print area also protects large sheets: a 300-row register no longer drags a stray cell from another tab into the output.

Page Setup offers three philosophies. Fit the sheet to one page, which scales everything down; fit to width, which fits the columns and lets rows flow across pages; or leave the scale manual, which keeps the size predictable at the cost of broken boundaries.

Orientation should follow the sheet's shape: wide tables take landscape, tall registers take portrait. Margins matter more than most people assume — default margins on a twelve-column sheet can be the difference between five pages and six.

A one-centimetre margin reduction often rescues a report that was one column short of fitting.

On a multi-page ledger, the header must appear on every page or the second page becomes unreadable. Set rows to repeat at top in Page Setup before converting, so column names ride along on every page.

The same trick works for a repeating first column in very wide reports — freeze and repeat whatever the reader needs on every page.

Deepak Gupta runs a fasteners unit in Ludhiana, and his production and despatch register is twelve columns wide and 320 rows long. The first conversion cut the sheet at column J and produced eleven half-filled pages. Setting landscape, fit-to-width and a repeating header row turned the same sheet into six clean pages — with the closing quantity visible on every last row.

The rule of thumb is one logical block per page: check page break preview and drag any split that lands mid-record, because a row broken across two pages is the most common silent defect in converted reports.

Browser converters open the workbook and honour its page setup — print areas, fit settings and orientation are respected because they live inside the workbook itself. No Office licence is needed.

For confidential sheets — salary structures, cost sheets, stock valuations — a local-processing converter keeps the workbook and its formulas on your device from start to finish.

Tax invoices carry many narrow columns — HSN, rate, taxable value, CGST, SGST — and fail at the page boundary in exactly the same way as any wide table. Landscape with fit-to-width and a repeating header is the reliable setup for them.

Five checks before pressing convert catch nearly every failure, and all of them happen in the preview pane. What the preview shows is what the file will contain — trust it.

Page setup travels with the workbook. Set it once on a template — the month-end register, the invoice sheet, the MIS dashboard — and every future conversion inherits the settings, turning the monthly job into one click.

Crafex's Excel-to-PDF converter runs in the browser with the workbook staying on your device, and the last column will be exactly where you left it.

A workbook that arrives in PDF as one sheet at a time comes from a mis-set print area on the extra sheets. Each sheet carries its own page setup, so define a print area per sheet — the GST export summary, the receivable ageing and the trial balance each get their own block.

When a workbook has W-2-style supplementary columns on a second sheet that must never reach clients, the print-area discipline is what keeps them out. The rule is one sentence: what the client sees is exactly the print area, nothing more.

Batch the per-sheet settings once at quarter start, and the monthly exports become a repeatable drill that ends on the same column, font size and orientation every time.

When only a slice of a large register matters — the current month's sales, the latest stock movement — define the print range to cover exactly those rows. The output then reads like a report instead of a workbook excerpt, and the recipient stops scrolling through months they never wanted.

Keep the full-sheet conversion as a separate monthly export; the range version is the shareable one. Two files, two jobs, no reader confusion between 'the full ledger' and 'this month's extract'.