Document Printing / 7 min
How Do You Print Excel Sheets Without Cutting Off Columns?
Set the print area, orientation, page breaks and scaling before exporting an Excel sheet for printing.
Published / Updated
By BizBee. Factual review: BizBee operations.
Short answer
To stop Excel columns being cut off, set the print area, choose orientation, review page breaks, use scaling carefully and export a PDF for inspection before ordering. Do not rely on the spreadsheet view: the print preview or exported PDF is the version that matters.
Why do Excel columns get cut off?
Excel worksheets can be much wider than a printed page. If the print area, paper size, orientation or scale is wrong, columns can spill onto extra pages or disappear from the intended sheet.
A spreadsheet can look correct on a screen and still print poorly because the screen view is not the print layout.
How should you set the print area?
Select only the cells that should print, then set the print area. Microsoft notes that each separate print area can print as a separate page, so avoid selecting disconnected ranges unless that is intended.
Use print preview or page break preview to confirm that the selected cells are the actual content you want.
When should you use landscape or A3?
Use landscape orientation when the sheet is wider than it is tall. Consider A3 when a wide table is still too cramped on A4.
Enlarging the paper is not a cure for messy data. Remove unused columns, shorten headings and check whether the reader can follow the table.
Should you fit all columns on one page?
Fitting all columns on one page can help, but it can also make text too small. Use it only after checking the exported PDF at a realistic printed size.
If the sheet becomes unreadable, split the table into logical sections instead of forcing everything onto one sheet.
Excel print checklist
- - Set the correct print area before exporting.
- - Choose portrait, landscape, A4 or A3 based on the table shape.
- - Review page breaks before saving the PDF.
- - Check whether fitting all columns makes text too small.
- - Open the exported PDF and confirm the final page count.
Next step
Export the checked Excel sheet to PDF, then upload the PDF to the print builder.
Print an exported spreadsheet PDF