Printing Problems

Fix Extra Columns and Page Scaling When Printing in Excel

Maira MehtabMaira Mehtab Nov 20, 2026 870 views

Question details

The user needs to print the intended Excel content without extra columns, excessive blank space, or incorrect scaling.

Fix Extra Columns and Page Scaling When Printing in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Printing a worksheet that may have workbook-specific formatting or print settings.
Observed behavior
The printout may contain only part of the intended content, unexpected columns, or excessive empty space.
Before you start

Open File > Print and compare the preview with the worksheet range you want to print. Check whether the same problem occurs in another workbook; the Safe Mode and Office repair steps below apply to Windows.

Solution 1Recommended

Set the Excel print area and adjust page scaling

Use these settings when the print preview includes unwanted columns, blank space, or content spread across too many pages.

1
Select the intended range

Select the cells you want to print, then choose Page Layout > Print Area > Set Print Area. To remove an incorrect existing range first, choose Print Area > Clear Print Area.

2
Adjust the scaling

On the Page Layout tab, use Scale to Fit to set Width to 1 page and Height to Automatic. This keeps the selected columns together while allowing rows to span multiple pages.

3
Check the preview

Open File > Print and review each page. If needed, adjust the orientation, margins, or paper size in the print settings before printing.

Set the Excel print area and adjust page scaling
Check for small print: Fitting many columns on one page can make text difficult to read. Consider landscape orientation, a larger paper size, or allowing more than one page across.
Free Microsoft Office alternative

Print Excel-Compatible Spreadsheets with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files, review print settings, and continue working with your existing documents. It does not repair Microsoft Excel itself.

Review spreadsheet print settings and page layout before printing.Compatible with Microsoft Excel XLS and XLSX formats.Familiar spreadsheet interface makes the switch easier.Free and lightweight for everyday document work.
microsoft office alternative - wps office

Frequently Asked Questions

How do I stop Excel from printing unwanted columns?

Select only the cells you need, then choose Page Layout > Print Area > Set Print Area. Check File > Print to confirm the preview excludes the unwanted columns.

Why is my Excel printout too small?

A setting that fits many columns or an entire sheet on one page can shrink the content. In Page Layout > Scale to Fit, try setting Height to Automatic, or allow more pages across.

How can I tell whether an add-in is causing the printing problem?

On Windows, close Excel, press Windows+R, enter excel /safe, and open the workbook. If the preview works in Safe Mode, restart Excel normally and test add-ins under File > Options > Add-ins.

What if only one workbook prints incorrectly?

First check its print area and scaling on the Page Layout tab. If the issue persists, copy the needed content into a new workbook and check its print preview; recreate any required query connections.