Printing Problems

Fix Missing Columns When Printing an Excel Spreadsheet on A3 Paper

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

The user needs to print a large Excel worksheet on A3 paper without losing the far-right columns.

Fix Missing Columns When Printing an Excel Spreadsheet on A3 Paper
Product
Microsoft Excel
Device & OS
not provided
Scenario
Printing a wide spreadsheet on A3 paper.
Observed behavior
Columns on the far right are missing from the printed output.
Before you start

Confirm that your printer supports A3 paper and that A3 paper is loaded in the correct tray. Open the worksheet and identify the last column that must appear in the printout.

Solution 1Recommended

Match the A3 settings and fit the worksheet columns

Use this method to correct paper size, print area, and scaling settings that can leave columns out of the output.

1
Set the worksheet paper size

In Excel, open the worksheet and select Page Layout > Size > A3. If the sheet is wide, select Page Layout > Orientation > Landscape.

2
Check the print area

Select all cells you need to print, including the far-right columns, then choose Page Layout > Print Area > Set Print Area. Alternatively, choose Clear Print Area to remove an unwanted restriction.

3
Fit columns to the page width

On the Page Layout tab, use Scale to Fit to set Width to 1 page and Height to Automatic. If needed, select Margins and choose a narrower preset.

4
Match the printer paper size

Select File > Print, choose your printer, and open Printer Properties. Set the printer's paper size to A3 and select the tray containing A3 paper.

5
Review and print

In File > Print, check the preview and move through all pages to confirm that the required columns appear. Adjust scaling or margins if necessary, then select Print.

Match the A3 settings and fit the worksheet columns
Check the text size: Fitting a very wide worksheet to one page can make the text small. If readability suffers, allow the columns to span multiple pages and check each page in Print Preview.
Print spreadsheets with WPS

Print a wide spreadsheet on A3 with WPS Spreadsheet

Open your workbook in WPS Spreadsheet, set the page and printer to A3, and use print preview and scaling to include the columns you need.

  1. 1. Open the workbook: Open WPS Spreadsheet and select Open to choose your Excel workbook.
  2. 2. Set the page layout: Select Page Layout > Size > A3, and choose Landscape under Orientation if the worksheet is wide.
  3. 3. Set the print area: Select the cells to print, including the far-right columns, and use Page Layout > Print Area to set the selection.
  4. 4. Check scaling and printer settings: Open File > Print, choose a fit-to-page-width scaling option if available, and set A3 in the selected printer's properties.
  5. 5. Preview and print: Review the print preview for all required columns, adjust the layout if needed, and select Print.
Adjust page size and scaling for wide A3 printoutsOpen and edit Microsoft Excel XLSX and XLS filesPreview the worksheet before printingUse familiar spreadsheet layout and print controls
microsoft office alternative - wps office

Frequently Asked Questions

Why are the rightmost Excel columns missing from my A3 printout?

The print area may exclude them, the worksheet and printer may use different paper sizes, or the columns may be on another page. Check Page Layout > Print Area and review every page under File > Print.

How do I fit all columns on one printed page?

In Excel, go to Page Layout > Scale to Fit and set Width to 1 page and Height to Automatic. Check File > Print to make sure the resulting text is still readable.

Do I need to select A3 in both Excel and the printer settings?

Yes. Set A3 under Page Layout > Size in Excel, then open Printer Properties from File > Print and select A3 there as well. The printer must support A3 paper.

What if the print preview is correct but the output is still cut off?

Confirm A3 and the correct paper tray in Printer Properties. If the problem persists, download and install the latest driver for your printer model from the manufacturer's support site, then test again.