Fix Missing Columns When Printing an Excel Spreadsheet on A3 Paper
Question details
The user needs to print a large Excel worksheet on A3 paper without losing the far-right columns.

- 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.
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.
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.
In Excel, open the worksheet and select Page Layout > Size > A3. If the sheet is wide, select Page Layout > Orientation > Landscape.
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.
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.
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.
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.

Update or reinstall the printer driver
Try this if the A3 and scaling settings are correct but the printed output is still incomplete.
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. Open the workbook: Open WPS Spreadsheet and select Open to choose your Excel workbook.
- 2. Set the page layout: Select Page Layout > Size > A3, and choose Landscape under Orientation if the worksheet is wide.
- 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. 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. Preview and print: Review the print preview for all required columns, adjust the layout if needed, and select Print.

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.




