Why do my Excel columns get cut off when I print?

The default print setting in Excel ignores page width and simply prints columns in order, breaking wherever the paper edge falls. Use Page Layout → Scale to Fit → Width: 1 page to force all columns onto one page width, then check Print Preview to verify.

Should I print a spreadsheet in portrait or landscape?

Landscape is almost always better for wide tables. Landscape A4 gives 297 mm of printable width vs. 210 mm in portrait. Switch via Page Layout → Orientation → Landscape. For narrow tables with few columns, portrait may be sufficient.

How do I repeat column headers on every printed page?

In Excel: Page Layout → Print Titles → Rows to repeat at top → select your header row. In Google Sheets: File → Print → Headers and footers. This ensures every page of a long table shows column labels.

Can I print only selected cells in Excel?

Yes. Select the cells you want, then go to Page Layout → Print Area → Set Print Area. Alternatively, in the Print dialog you can choose 'Print Selection' from the dropdown. This prevents blank columns or irrelevant worksheets from appearing.

Can I upload an Excel file directly to Printster?

Printster accepts XLSX and other Office formats. However, for the most reliable output — especially for wide or complex tables — export your sheet to PDF first using File → Save As → PDF and upload the PDF. This locks the layout exactly as you designed it.

How long does Printster take to deliver a printed spreadsheet or report?

Delhi NCR: 4–7 working days. Rest of India: 7–10 working days, counted from the next working day after your order. For simple unbound printouts without binding, delivery falls at the lower end of this range.

How to Print a Spreadsheet Cleanly

To print an Excel sheet without cutting off columns, go to Page Layout → Scale to Fit → set Width to '1 page'. Then check Print Preview, set orientation to Landscape for wide tables, and export as PDF before uploading to a print service. This ensures all columns fit neatly on each printed page.

Printing a spreadsheet sounds simple until you get a printout with columns sliced off mid-number or rows continuing endlessly across a dozen pages with no headers to guide you. Excel and Google Sheets are not designed with paper in mind — they are built for infinite scrolling. Getting a clean, readable printout requires a few deliberate settings that most people never discover. Whether you are printing a financial summary, a project timeline, an inventory list, or exam marks, the goal is the same: every cell should appear on the right page, with clear column and row labels on every sheet, and no content spilling off the edge. This guide gives you a reliable workflow that works in Microsoft Excel, Google Sheets, and LibreOffice Calc.

Step 1 — Set Your Print Area

Before adjusting any layout settings, tell the spreadsheet exactly what you want to print. Select the cells you need, then go to Page Layout → Print Area → Set Print Area (Excel) or File → Print → Set Print Range (LibreOffice). This prevents blank columns or worksheets from appearing in the printout.

If your sheet spans multiple worksheets, select all relevant sheets (hold Shift and click each tab) before printing.

Step 2 — Scale to Fit

The most common fix for columns being cut off:

Excel: Page Layout tab → Scale to Fit group → set Width to '1 page'. Leave Height on 'Automatic' so rows still flow naturally across multiple pages. You can also go to File → Print → Page Setup → Fit to → '1 page wide'.

Google Sheets: File → Print → Scale → Fit to width or Fit to page.

Scaling compresses your content to fit the page width. If you scale too aggressively (many columns on one A4 page), the font becomes tiny. If the result is below 8 pt, consider splitting the table across two portrait pages instead.

Step 3 — Choose Orientation

Wide tables with many columns almost always print better in Landscape orientation. Go to Page Layout → Orientation → Landscape (Excel) or File → Print → Layout → Landscape (Google Sheets). Landscape gives you 297 mm of width on A4 instead of 210 mm — a 41% wider printable area.

Step 4 — Print Row and Column Headings on Every Page

For tables that span multiple pages, repeating headers on each page is essential. In Excel: Page Layout → Print Titles → Rows to repeat at top. Click the selector icon and click the header row. Now every page of the printout will show column labels.

In Google Sheets, this option is available under File → Print → Headers and footers.

Step 5 — Export as PDF Before Uploading

Once the Print Preview looks clean in Excel or Sheets, export to PDF: File → Save As → PDF (Excel) or File → Download → PDF (Google Sheets). Uploading the PDF to Printster gives the most predictable output — the printer receives exact page layouts rather than re-flowing the spreadsheet.

Printster also accepts XLSX files directly, but exporting as PDF yourself avoids any software version differences affecting column widths or fonts on the print side.

Upload your file & get an instant price

Frequently asked questions

Why do my Excel columns get cut off when I print?: The default print setting in Excel ignores page width and simply prints columns in order, breaking wherever the paper edge falls. Use Page Layout → Scale to Fit → Width: 1 page to force all columns onto one page width, then check Print Preview to verify.
Should I print a spreadsheet in portrait or landscape?: Landscape is almost always better for wide tables. Landscape A4 gives 297 mm of printable width vs. 210 mm in portrait. Switch via Page Layout → Orientation → Landscape. For narrow tables with few columns, portrait may be sufficient.
How do I repeat column headers on every printed page?: In Excel: Page Layout → Print Titles → Rows to repeat at top → select your header row. In Google Sheets: File → Print → Headers and footers. This ensures every page of a long table shows column labels.
Can I print only selected cells in Excel?: Yes. Select the cells you want, then go to Page Layout → Print Area → Set Print Area. Alternatively, in the Print dialog you can choose 'Print Selection' from the dropdown. This prevents blank columns or irrelevant worksheets from appearing.
Can I upload an Excel file directly to Printster?: Printster accepts XLSX and other Office formats. However, for the most reliable output — especially for wide or complex tables — export your sheet to PDF first using File → Save As → PDF and upload the PDF. This locks the layout exactly as you designed it.
How long does Printster take to deliver a printed spreadsheet or report?: Delhi NCR: 4–7 working days. Rest of India: 7–10 working days, counted from the next working day after your order. For simple unbound printouts without binding, delivery falls at the lower end of this range.