Fit All Columns on One Page in Excel Not Working?

If Fit All Columns on One Page is not working in Excel, check the active sheet’s scaling, print area, and paper settings. In Excel for Microsoft 365 on Windows, go to Page Layout > Scale to Fit, set Width to 1 page and Height to Automatic, then check the result in File > Print.

Apply the setting that fits columns across a page

Excel has two related ways to scale a worksheet for printing. The ribbon method is usually the clearest place to troubleshoot because it lets you fit the width without also squeezing the sheet’s height onto a single page:

Select the worksheet you want to print. If several sheet tabs are selected, click a single tab unless you intend to print the grouped sheets.
Open Page Layout. In the Scale to Fit group, set Width to 1 page.
Set Height to Automatic. This lets the sheet continue onto additional pages vertically instead of shrinking every row onto one page.
Open File > Print and inspect the preview. If needed, choose the printer and paper size you actually plan to use.

You can also use File > Print, open the scaling menu that may say No Scaling, and choose Fit All Columns on One Page. This is a quick print-time option. If a later setting or a different sheet selection changes the preview, return to Page Layout and confirm the width and height choices there.

To open the more detailed settings, use the Page Setup dialog launcher in the lower-right corner of the Page Setup group on the Page Layout tab. On the Page tab, choose Fit to and enter 1 page wide; leave the pages tall field blank or automatic if you want multiple pages vertically. The exact appearance of the dialog can vary with the Excel and printer setup.

Understand what Excel means by fitting columns

Fit All Columns on One Page means Excel scales the printed worksheet so its printable width fits across one page. It does not necessarily mean the entire worksheet fits on one page. If there are enough rows, Excel can print several pages down, with the same reduced width on each page.

That distinction matters because the similarly named Fit Sheet on One Page option scales both the width and the height to one page. A sheet with hundreds of rows can become too small to read when both dimensions are forced onto one sheet of paper. To keep columns together while allowing a sensible number of pages vertically, set Width to 1 page and Height to Automatic.

Scaling affects the printed output and its preview, not the worksheet’s actual column widths or on-screen zoom. If the columns look unchanged in Normal view, that is expected. Check File > Print or use Page Layout view to see how the print layout is being scaled.

Check the print area and selected sheets

A print area tells Excel which cells to include when printing. If an old print area excludes columns you expect to see, or includes a large blank region far to the right, the preview may appear to ignore your intended layout. On the Page Layout tab, open Print Area. Choose Clear Print Area to remove an existing boundary, or select the intended range first and choose Set Print Area.

For example, suppose your report uses columns A through H, but a print area was previously set to A through D. The print preview will not include E through H simply because you choose Fit All Columns on One Page. Conversely, a print area that stretches to column XFD can force the useful data to shrink dramatically, even if those extra columns look empty. Check the print-area boundary in Page Break Preview and clear or reset it when necessary.

Also verify what Excel is set to print. In File > Print, inspect the settings menu for options such as Print Active Sheets, Print Entire Workbook, or Print Selection. Print Selection uses only the cells selected when you opened the print screen. If the wrong option is selected, the output can differ from the worksheet you intended to scale.

Confirm paper size, orientation, and margins

Excel fits content to the printable area of a page, not to the full physical dimensions of the paper. Printer margins, a selected paper size, and the printer’s own non-printable edges all affect the available width. A setting for Letter paper can produce a different layout from A4, and a mismatch between Excel’s selected paper and the loaded paper can make the printed result surprising.

On Page Layout, choose Orientation > Landscape when the data is wider than it is tall.
Choose the paper size that matches the intended output, such as Letter or A4, using Page Layout > Size.
Try Page Layout > Margins > Narrow if the report has room for smaller margins and the printer supports them.
In File > Print, confirm the selected printer and compare its preview with the paper and orientation you intend to use.

Changing orientation or margins gives Excel more horizontal room, but it cannot make an extremely wide report readable at any size. Use those options to recover useful space, not as a substitute for removing unnecessary columns or choosing a larger paper format.

Look for conflicting scaling or page setup choices

Excel’s page setup offers two different scaling approaches: a percentage under Adjust to, or page counts under Fit to. Fit to is the setting that specifies a target number of pages wide or tall. If you are troubleshooting, select Fit to and set the width to one page rather than expecting a percentage setting to achieve the same result. In the ribbon, the Scale to Fit width and height boxes provide a convenient way to set that target.

Manual page breaks can also make the preview confusing. A manual vertical break may divide the sheet into separate pages, while fitting to a page count can override manual breaks. If the preview does not match the breaks you set, review them under Page Layout > Breaks. You can choose Reset All Page Breaks to return to automatic breaks, but do this only if you are willing to discard the manual break layout.

After changing settings, check the correct worksheet and preview again. Page setup is associated with worksheets, so a fix on one tab does not automatically establish the same print layout on every other tab. If several sheets are grouped, changes may apply to all selected sheets; check the tab selection before editing and ungroup them when finished.

Fix a result that technically fits but is unreadable

Sometimes the option is working exactly as requested: every column fits across one page, but the text becomes tiny. This is common with wide data exports containing many fields, long descriptions, or columns that are wider than their contents require. Excel has to reduce the scale enough to fit the total width into the printable area.

Before forcing a smaller scale, consider whether every column belongs in the printed report. Hide columns that are not needed for the printout, or create a separate report sheet containing only the relevant fields. You can also use shorter headings, wrap text in headings, adjust column widths, and remove empty columns mistakenly included in the print area. These changes can preserve readability without changing the source data.

For a very wide report, alternatives include printing on larger paper, splitting the report into logical sections, or allowing columns to span multiple pages. If the columns must remain on one page, use Print Preview to judge whether the text is legible at the selected scale before printing. A preview that looks too small on screen is a warning that the paper copy may be difficult to use.

Use page views to diagnose the layout

Print Preview is the fastest way to verify what Excel will send to the printer. Open File > Print and use the page navigation controls to inspect every page, not just the first one. Check that the leftmost and rightmost columns are both present and that the report continues vertically as expected.

Page Layout view, available from the View tab, shows worksheet pages and their margins in the grid. Page Break Preview, also on the View tab, makes page boundaries easier to see and lets you identify an unexpected print range or page break. These views help diagnose layout, but File > Print remains the final check because its preview reflects the selected print settings and printer.

For routine reports, consider saving the workbook after confirming the page setup. Keep in mind that a different printer, paper size, or print setting can change the output. If the workbook is shared, tell the next person which sheet and print range are intended; otherwise, they may be looking at a different print selection.

Excel for Mac and Excel for the web

On Excel for Mac, the same general idea applies: set the page to fit one page wide while leaving the height automatic, then inspect the print preview. Ribbon labels and the location of detailed Page Setup controls can differ by Mac version. The Windows shortcut Ctrl+P opens Print; on a Mac, use Command+P. Do not assume that a Windows screenshot’s exact dialog layout will match your Mac.

Excel for the web has a more limited printing interface than the desktop application, and available page setup controls can differ. If you cannot find a width-to-one-page control in the web interface, open the workbook in the desktop Excel app and set the scaling there, then review the resulting print preview. Menu availability can change, so use the options shown in your version rather than relying on a desktop-only path.

Frequently Asked Questions

Why does Excel still print my columns on multiple pages?
Check that the width is set to 1 page, that the correct sheet is active, and that File > Print is not set to Print Selection or another unintended option. An existing print area or a different sheet’s page setup can also affect the result.

Does Fit All Columns on One Page fit all rows too?
No. It fits the width to one page and can let the rows continue over several pages. Choose Fit Sheet on One Page only when you want both dimensions on a single page, and be aware that the text may become very small.

Why is the print so tiny after I choose this option?
Excel is shrinking the total width of the included columns to fit the paper’s printable area. Remove unnecessary columns from the print area, adjust column widths, use landscape orientation, or choose larger paper before accepting an unreadable scale.

Will changing column width in the worksheet fix the print scaling?
It can help if columns are wider than needed, but worksheet zoom is unrelated to print scaling. Check the result in File > Print, and confirm that the intended print area does not include unused columns.

Can I make the setting apply to every worksheet?
Page setup is associated with individual sheets. You can select multiple sheet tabs before making changes, but grouped sheets can be edited together unintentionally. Confirm the selected tabs first and ungroup them after applying the shared settings.

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.