Excel Print Area: Center It on a Page and Fix Layout

To center a print area on a page in Excel for Microsoft 365 on Windows, open Page Layout > Margins > Custom Margins, then under Center on page select Horizontally, Vertically, or both. These settings center the worksheet’s printed content within the page margins; they do not center the text inside worksheet cells.

If you want only a particular range to print, set that range as the print area first, then check the result in Print Preview. Centering is a page-layout setting, so it works alongside—but does not replace—choosing the print area, paper size, orientation, margins, and scaling.

What centering a print area does

Excel normally positions printed worksheet content toward the upper-left of the printable region. The printable region is the portion of the sheet between the page margins. Selecting horizontal centering places the content midway between the left and right margins. Selecting vertical centering places it midway between the top and bottom margins. You can choose either direction or both.

Centering affects the printed output and its preview, not the worksheet grid on screen. It does not change cell values, column widths, row heights, or the alignment of text within cells. For example, if a small report occupies columns B through F but the printed page is much wider, horizontal centering positions the report in the middle of the usable page width. The entries in each cell keep their existing left, center, or right alignment.

The setting applies to the active worksheet’s page layout. If the sheet prints across several pages, Excel lays out the content on those pages according to its page breaks and print settings. Centering is not a command to gather all the pages into one sheet of paper; it only affects positioning within the page or pages being printed.

Set a print area before centering

A print area tells Excel which cells to include when printing a worksheet. It is useful when a sheet contains working notes, source data, or extra columns that should remain in the workbook but not appear in the report. Select the range you want, then use Page Layout > Print Area > Set Print Area. Excel outlines the print area on the sheet.

For example, if a monthly summary is in A1:G28 and transaction details continue below it, select A1:G28 before setting the print area. When you print the sheet, Excel uses the defined area instead of printing all the used cells. You can still change margins, orientation, centering, and scaling for that output.

To remove the defined area, use Page Layout > Print Area > Clear Print Area. Clearing it does not delete any worksheet content; it simply returns printing to Excel’s default treatment of the sheet’s used cells. A print area is saved with the workbook, so it can affect a later print job even if you do not remember setting it.

When a range is already selected, you can also choose File > Print and select the option to print the selection. That is useful for a one-time print, while a saved print area is more convenient for a report you print repeatedly. In either case, use the preview to confirm what Excel is including.

Center the worksheet horizontally or vertically

Click the worksheet tab you intend to print. If needed, define its print area using Page Layout > Print Area > Set Print Area.
On the ribbon, select Page Layout > Margins > Custom Margins. This opens the Page Setup dialog box on its Margins tab.
Under Center on page, select Horizontally to center from left to right, Vertically to center from top to bottom, or both boxes to center in both directions.
Select OK, then open File > Print to inspect the preview. Adjust the layout if the range does not fit or does not look balanced.

These settings are particularly helpful for a small table or a one-page form. A compact report can otherwise sit awkwardly in a corner of a sheet of paper. If a report is intentionally aligned toward the top—for example, a letter-style page with space below for notes—leave vertical centering off and use horizontal centering only.

You can also open the Page Setup dialog from the small dialog box launcher in the lower-right corner of the Page Setup group on the Page Layout tab. Its Margins tab contains the same centering controls. The launcher is useful if you are already working with other page settings on the ribbon.

Check the preview and page boundaries

Print Preview is the quickest way to tell whether centering achieved the intended result. In Windows Excel, press Ctrl+P or choose File > Print. The preview shows the output based on the current printer and page settings. Use the page navigation controls when the worksheet spans more than one page; a pleasing first page does not guarantee that every later page is arranged as intended.

Look at the edges of the printed range, the amount of blank space, and whether any columns or rows have spilled onto another page. If available in your Excel window, page break preview can also help you see where Excel divides the sheet. Return to the Page Layout tab to change paper size, orientation, margins, or scaling, then check the preview again.

Do not judge the result only by the selected cells on the worksheet. The selected range may be smaller than the saved print area, and the preview may include headers, footers, or repeating title rows. Conversely, a range can appear large on screen but print small when scaling is set to fit it on one page.

Centering versus scaling and margins

Centering controls position; scaling controls size. If a wide table is too large to fit across a page, centering it will not make it narrower. You may need to change the orientation to Landscape, reduce margins, adjust column widths, or use the scaling options in the Page Layout tab’s Scale to Fit group. You can also inspect the scaling choices in the Print settings.

Excel’s fit-to-page choices can shrink content substantially, especially when you try to fit many rows and columns onto one sheet of paper. A tiny report may technically fit but be difficult to read. Consider fitting the sheet to one page wide while allowing it to use multiple pages tall, or print on larger paper if your printer supports it. Check the preview at the actual intended paper size.

Margins also affect the area in which Excel centers content. A narrow left margin and a wide right margin can make a centered range look off-center relative to the physical page, even if it is centered between the margins. Set balanced margins if you want the report to appear centered on the paper itself. Printer hardware may impose minimum printable margins, so the physical result can differ slightly from the preview.

Multiple pages, print titles, and sheet settings

A print area can span several pages horizontally or vertically. Centering does not remove page breaks or combine those pages. If a table is split in an inconvenient place, use Page Layout > Breaks to manage page breaks, or change the scaling and orientation. Always inspect each page in the preview, particularly if a printed report must keep related columns together.

For a long table, repeating the header row on each printed page is often more useful than centering the whole output vertically. Use Page Layout > Print Titles to open Page Setup and specify rows to repeat at the top or columns to repeat at the left. Print titles provide context on subsequent pages; they do not change which cells belong to the print area.

Each worksheet can have its own print area and page setup. If you select several sheet tabs together and change page settings, Excel may apply the change to all grouped sheets. Grouped tabs are usually indicated by their highlighted appearance. Click a single sheet tab before making a change if you only intend to alter one worksheet. When finished, check the other sheets individually before printing a multi-sheet workbook.

Common centering problems and fixes

The content still looks too far to one side: Check whether the left and right margins differ. Centering is between the margins, not necessarily between the paper edges. Also confirm that the print area includes the complete intended range.
Only part of the report appears: Review Page Layout > Print Area and clear or reset the print area if it is outdated. Check Print Preview for hidden rows or columns and confirm the selected sheet is the one you mean to print.
The report is centered but too small: Look at the scaling setting. Centering does not control the zoom or printed size. Use a more suitable paper size or orientation, or allow the report to span additional pages.
The printed output differs from the preview: Confirm the selected printer and paper size in the print screen. Printer drivers can have different paper defaults and printable margins. A different printer may change page breaks or scaling.
The whole workbook does not share the same layout: Page setup can differ between worksheets. Configure and preview each sheet, or carefully group sheets only when you intend to apply the same settings to all of them.

A common misconception is that the worksheet’s Home tab alignment buttons control where a report sits on the printed page. Those buttons align content within cells. For page positioning, use the centering checkboxes in Page Setup. The two kinds of alignment can be used together: center a title within merged or selected cells, for instance, and separately center the printout horizontally on the page.

Excel for Mac and Excel for the web

In Excel for Mac, select the worksheet and open the page setup or margin controls from the Page Layout tab. Choose the custom margin or Page Setup options and look for the horizontal and vertical centering controls on the Margins tab. Ribbon labels and dialog placement can differ slightly by Mac version, but the setting is still a page-layout option. To preview, use File > Print or press Command+P; Windows uses Ctrl+P.

Excel for the web has a more limited print-layout workflow than the desktop application, and its available controls can vary as Microsoft updates the service. If you cannot find the Center on page options or need precise control over margins, print areas, and page breaks, open the workbook in desktop Excel and set up the sheet there. Before printing from any version, review the preview so you can catch differences in paper size and page breaks.

Frequently Asked Questions

How do I center an Excel printout horizontally?
Choose Page Layout > Margins > Custom Margins. Under Center on page, select Horizontally, choose OK, and check File > Print.

How do I center a print area both vertically and horizontally?
In the Custom Margins dialog’s Margins tab, select both Horizontally and Vertically under Center on page. Preview the output to ensure the result suits the report.

Why is my Excel print area not centered?
Check that the centering boxes are selected for the correct worksheet, and verify the left and right margins. Also confirm that the saved print area and scaling settings are correct; centering cannot compensate for an incorrect range or uneven margins.

Does centering the print area center text in the cells?
No. It positions the printed content between the page margins. To center text inside cells, use the alignment controls on the Home tab separately.

How do I print only part of a worksheet?
Select the cells and choose Page Layout > Print Area > Set Print Area to save a print area. For a one-time job, you can choose to print the selection from the File > Print screen instead.

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.