Excel Not Printing All Columns? Fix the Page Setup

Errors & fixes · Updated November 18, 2026

If Excel is not printing all your columns, check the print area first, then set the worksheet to fit one page wide: in Excel for Microsoft 365 on Windows, open Page Layout, set Width to 1 page and Height to Automatic under Scale to Fit, and inspect the result with Ctrl+P. If columns are still missing, look for hidden columns, manual page breaks, a selected print range, or a paper-size mismatch.

Why Excel may leave columns off the printout

A worksheet is effectively wider than a printed page can be. Excel normally divides a sheet into as many printed pages as needed, but settings can limit what is included or make the page divisions less obvious. A worksheet that appears to show every column on screen may therefore print across multiple pages, or print only a selected portion.

There are two different problems that readers often describe as Excel not printing all columns:

  • Some columns do not print at all. A print area may exclude them, the columns may be hidden, or the print command may be set to print a selection or active sheet rather than the intended range.
  • Columns continue on another page. This is usually normal pagination. The columns are not missing; they are on a second or later page. Scaling or changing the page layout can bring them together.

Start by opening Print Preview with Ctrl+P. It shows what Excel is preparing to send to the printer, including page boundaries and scaling. If the preview itself omits columns, investigate the workbook settings. If the preview includes them but the physical print does not, the printer or its driver may be involved.

Fit every column across one page

To keep all columns together while allowing rows to continue onto additional pages, set the sheet to one page wide and leave its height automatic. In Excel for Microsoft 365 on Windows, select the worksheet, open the Page Layout tab, and find the Scale to Fit group. Set Width to 1 page and Height to Automatic. Then use Ctrl+P to review the preview.

This setting reduces the printed size as necessary to fit the sheet’s used width on a single page. It does not change the cells or their values, and it does not necessarily make the entire worksheet one page tall. That distinction matters for long tables: one page wide with several pages down is usually more readable than squeezing every row and column onto one sheet of paper.

You can also reach scaling choices from the print screen. Press Ctrl+P, open the scaling option under Settings—often shown as No Scaling—and choose Fit All Columns on One Page. The wording can vary slightly with the printer and Excel build. Review the preview after changing it; the print preview is the best way to confirm that the intended columns are present.

For a very wide worksheet, fitting all columns may shrink the text until it is difficult to read. Consider landscape orientation, narrower margins, a larger paper size, or splitting the report into logical sections instead. Scaling is a useful layout tool, not a guarantee that every table will remain legible at any width.

Check the print area and print selection

A print area is a saved range that tells Excel which cells to print. It can remain in a workbook after someone has used it previously, so a printout may stop at a particular column even though more data is visible. To remove it in Windows, go to Page Layout > Print Area > Clear Print Area. Open Print Preview again to see whether the omitted columns return.

If you want to define a new print area, select the full range to print, including the columns that were missing, and choose Page Layout > Print Area > Set Print Area. Be aware that setting a print area replaces the existing one for that sheet. To print the entire used worksheet instead, clear the print area and choose the appropriate print option in the File > Print screen.

Also check what Excel is set to print. In File > Print, the Settings menu may offer options such as Print Active Sheets, Print Entire Workbook, or Print Selection. Print Selection is appropriate only when you deliberately selected the complete desired range. If the selection stops short of the rightmost column, Excel will faithfully omit the unselected columns.

Print areas are worksheet-specific. A workbook with several sheets can have different print areas and page settings on each sheet. If you print the entire workbook, inspect the preview for each sheet, especially if only one tab is affected.

Look for hidden columns and manual page breaks

Hidden columns are not printed as ordinary visible columns. Check the column headings for gaps—for example, headings A, B, D may indicate that C is hidden. Select the headings on either side of the gap, right-click, and choose Unhide. You can also select the whole worksheet using the triangle at the upper-left corner of the grid, then use Home > Format > Hide & Unhide > Unhide Columns. Review the sheet first: unhiding may reveal data that was intentionally concealed.

Manual page breaks can also make the print layout surprising. Choose View > Page Break Preview to see the page divisions. A solid blue line generally marks a manual break, while dotted lines indicate automatic breaks. You can drag a break to adjust where pages divide. To remove manual breaks and let Excel paginate automatically, choose Page Layout > Breaks > Reset All Page Breaks.

A page break usually moves columns onto a different page rather than deleting them. If the right side is missing even from every page in Print Preview, look beyond page breaks and check the print area, hidden state, or selected range. Page Break Preview is especially useful when a report prints several pages wide and you need to understand exactly where Excel is splitting it.

Adjust orientation, margins, and paper size

When columns are present but spread across too many pages, change the physical layout before reducing the scale aggressively. In Windows, use Page Layout > Orientation > Landscape for a wider page. For a report with many narrow fields, landscape can make a meaningful difference, though it will not make an unlimited number of columns fit.

Margins take up printable space. Choose Page Layout > Margins and try Narrow, or use Custom Margins to adjust the left and right margins. Check that the data does not become too close to the edge for the printer to handle. Printers have nonprintable areas, and a setting that looks acceptable in the preview may still be clipped by a particular device.

Confirm that Excel’s paper size matches the paper actually loaded in the printer. Use Page Layout > Size to select the intended size, such as Letter or A4, and compare it with the printer’s paper setting. A mismatch can cause the driver to scale or reposition a page unexpectedly. If the workbook is designed for legal, tabloid, or another larger paper size, printing it on Letter or A4 may force a much smaller scale or extra pages.

Page orientation, paper size, and margins are often the most readable first adjustments. Use them with Fit All Columns on One Page, then inspect the preview and a test print. The ideal combination depends on the worksheet width, the paper available, and whether the document needs to be read on paper or merely archived.

Make a wide worksheet easier to read

Fitting columns onto one page is not always the best answer. For example, a sales report with 12 columns may fit on landscape Letter paper, while a tracking sheet with 30 columns could become too small to read. Before accepting a tiny print scale, consider whether the sheet can be reorganized or whether the reader needs every field on the same page.

  • Remove unnecessary printed columns. If a field is useful in the workbook but not in the report, exclude it from a deliberately chosen print area rather than shrinking the whole sheet.
  • Use a summary sheet. Present the essential measures in a compact view and keep detailed records on a separate worksheet.
  • Split a report into sections. Print related groups of columns separately when readers do not need to compare every field side by side.
  • Repeat headings on continuation pages. If columns span multiple pages horizontally, use Page Layout > Print Titles to set rows to repeat at the top of each printed page. This helps readers identify the data, though it does not bring columns onto one page.

Another common misunderstanding is that freezing panes controls printed columns. Freeze Panes affects which rows or columns stay visible while scrolling on screen; it does not determine the print area or page scaling. Likewise, changing column width in the worksheet can help, but it may not be necessary if orientation or print scaling already solves the layout.

When the preview and printer disagree

If Print Preview shows every column but the paper copy does not, the workbook settings may be correct. Check the printer’s selected paper size, orientation, scaling, and printable-area options in the Windows print dialog or printer preferences. A driver setting such as fit to printable area can alter the result after Excel prepares the page.

Try printing the sheet to a PDF file as a diagnostic. If the PDF contains all columns and has the expected page layout, the issue is more likely in the printer, its driver, or its paper setup. If the PDF also omits columns, revisit Excel’s print area, print selection, hidden columns, and preview settings. A PDF is also useful for checking page breaks before using paper.

When the problem affects only one workbook, compare its Page Layout settings with a new blank workbook or another sheet. If multiple workbooks print incorrectly, check the printer setup and driver, and consider whether the problem occurs from another application too. This comparison helps distinguish a workbook-specific setting from a device-wide issue.

On Excel for Mac, the same core concepts apply, but ribbon placement and print dialogs can differ. Use the Page Layout tab and File > Print or Command+P to inspect printing options; Command+P is the Mac equivalent of Ctrl+P. Excel for the web also has a print flow through File > Print, followed by browser or PDF printing controls, and some page-layout controls differ from the desktop app. If a detailed setting is unavailable in the web version, open the workbook in the desktop Excel app.

Frequently Asked Questions

How do I print all Excel columns on one page?
In Excel for Microsoft 365 on Windows, choose Page Layout and set Width to 1 page and Height to Automatic in Scale to Fit. Alternatively, use Ctrl+P and choose Fit All Columns on One Page from the scaling options. Check the preview because a very wide sheet may print in small type.

Why does Excel print only the first few columns?
Common causes are a print area that ends too early, Print Selection being chosen with an incomplete range, or columns being hidden. Clear the print area, check the print setting, inspect the column headings for gaps, and review Print Preview.

Why are my columns on separate printed pages?
Excel is likely dividing a wide worksheet across multiple pages. Set the sheet to one page wide, or use landscape orientation, narrower margins, or larger paper. If the columns need to remain readable, keeping them on multiple pages may be preferable.

Does Freeze Panes affect printing?
No. Freeze Panes keeps selected rows or columns visible while you scroll through the worksheet on screen. It does not change what is printed. Use print areas, scaling, page breaks, and print titles to control the printed layout.

Why does the print preview look right but the paper is still cut off?
Check the printer dialog for a different paper size, orientation, scaling option, or printable-area limitation. Printing to PDF can help isolate the cause: a correct PDF points toward the printer or driver, while an incorrect PDF suggests an Excel layout setting still needs attention.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.