Your Excel spreadsheet prints with the rightmost columns missing. This happens because the sheet’s width exceeds the paper size set in your printer. The data spills onto a second page, which is often unwanted. This article explains the page layout settings that control printing. You will learn how to scale your worksheet to fit all columns on a single sheet.
Key Takeaways: Fit Excel Columns on One Page
- Page Layout > Width: 1 page: Scales the printout horizontally to fit the paper width, which is the most common fix.
- Page Setup dialog > Scaling > Fit to 1 page wide: Offers the same scaling control with more print option previews.
- View > Page Break Preview: Shows blue dashed lines representing print margins so you can adjust column widths manually.
Why Excel Columns Get Cut Off When Printing
Excel prints based on the physical dimensions of your paper. The default letter size is 8.5 inches by 11 inches. If the combined width of your columns is greater than 8.5 inches, the content will not fit. Excel does not automatically shrink the data. Instead, it splits the content across multiple pages according to the default print margins.
The print area is defined by visible gridlines and set margins. You can see these boundaries before printing. The Page Layout view and Print Preview show exactly what will be sent to the printer. Scaling is the feature that adjusts the size of your cells to match the paper. You can scale by percentage or force a fit to a specific number of pages.
Understanding Scaling vs. Manual Adjustment
Scaling reduces the size of everything on the sheet proportionally. Text, numbers, and graphics become smaller. Manual adjustment involves changing column widths or row heights yourself. This method gives you precise control but can be time-consuming for large sheets. For a quick fix, scaling is the recommended approach.
Steps to Scale and Fit All Columns on One Page
Use these methods in order. Start with automatic scaling, then check the preview. If the printout is too small to read, try the manual adjustment steps.
Method 1: Use the Ribbon to Scale Width to One Page
- Go to the Page Layout tab
Open your workbook and click the Page Layout tab on the Excel ribbon. - Open the Scale to Fit group
Look for the Scale to Fit group on the far right of the ribbon. It contains three dropdown boxes: Width, Height, and Scale. - Set the Width to 1 page
Click the dropdown under Width. Select “1 page” from the list. Leave the Height dropdown set to “Automatic”. - Check the Print Preview
Press Ctrl+P to open the Print Preview pane. Verify all your columns now appear on a single page. The scale percentage will update automatically.
Method 2: Use the Page Setup Dialog for Precise Control
- Open the Page Setup dialog
On the Page Layout tab, click the small dialog launcher arrow in the bottom-right corner of the Page Setup group. - Go to the Page tab
In the dialog box, ensure you are on the Page tab. - Select the Fit to option
Under Scaling, select the “Fit to” radio button. Set the first box to “1” page(s) wide. Set the second box to “1” page(s) tall, or leave it blank for automatic height. - Apply and preview
Click OK to apply the settings. Press Ctrl+P again to see the preview with all columns fitted.
Method 3: Manually Adjust Columns Using Page Break Preview
- Switch to Page Break Preview
Go to the View tab. Click the Page Break Preview button in the Workbook Views group. - Identify the print area
Your worksheet will display with blue dashed lines. These lines show the print margins and page breaks. Any column to the right of the vertical blue line will print on a second page. - Drag the page break line
Move your mouse cursor over the vertical blue dashed line. When the cursor changes to a double-headed arrow, click and drag the line to the right to include all your columns within one page. This action will shrink the column widths. - Return to Normal view
Go back to the View tab and click Normal. Your column widths will now be adjusted to fit the single page.
If Scaling Makes the Text Too Small or Other Issues Occur
Print Preview Still Shows Columns on a Second Page
Check your printer’s default paper size. Go to File > Print. Under Settings, click the paper size dropdown. Ensure it matches the size you configured in Page Layout, like Letter. Also, verify the print area is not manually set to exclude some columns. Go to Page Layout > Print Area > Clear Print Area.
Scaled Printout is Unreadably Small
Do not use the “Fit to” option. Instead, use custom scaling. In the Page Setup dialog, on the Page tab, select “Adjust to” and enter a percentage like 95% or 90%. Preview after each adjustment. Alternatively, change the page orientation. Go to Page Layout > Orientation > Landscape. This gives you more horizontal space and often avoids the need for severe scaling.
Only Specific Columns Are Cut Off
The issue might be a single very wide column. Select that column header. Right-click and choose Column Width. Reduce the width value. You can also use the Wrap Text feature. Select the cells with long text, go to the Home tab, and click Wrap Text. This forces text to multiple lines within the cell, reducing the column’s printed width.
Scaling to Fit vs. Manual Adjustment: Key Differences
| Item | Scaling to Fit (Automatic) | Manual Column Adjustment |
|---|---|---|
| Primary use | Quick one-click fix for entire sheet | Precise control over specific columns |
| Effect on content size | Reduces everything proportionally | Changes column width only, text size stays the same |
| Best for | Sheets where readability is less critical | Final reports where formatting must be preserved |
| Speed | Fast, single setting change | Slower, requires adjusting each column |
| Risk of data clipping | Low, scales entire content grid | High, if text is not wrapped or columns are too narrow |
You can now prevent Excel from cutting off the right side of your printouts. Use the Width setting in the Scale to Fit group for the fastest result. If the text becomes too small, try switching to Landscape orientation in Page Layout > Orientation. For advanced control, set a custom scale percentage in the Page Setup dialog to find the perfect balance between fit and readability.