Fix Extra Columns and Page Scaling When Printing in Excel
Question details
The user needs to print the intended Excel content without extra columns, excessive blank space, or incorrect scaling.

- 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.
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.
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.
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.
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.
Open File > Print and review each page. If needed, adjust the orientation, margins, or paper size in the print settings before printing.

Test Excel add-ins and repair Office on Windows
Use this approach if the problem occurs in multiple workbooks or persists after correcting the print settings.
Move the affected worksheet content to a new workbook
Try a new workbook if the printing problem is limited to one file and persists after checking its print settings.
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.

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.




