How to Find the Center of a Page in Excel for Printing

How-to basics · Updated November 20, 2026

To center worksheet content on a printed page in Excel for Microsoft 365 on Windows, open Page Layout > Margins > Custom Margins, then under Center on page select Horizontally, Vertically, or both. Click OK and check File > Print to see the result. These settings center the printout; they do not move cells or center the worksheet in the Excel window.

This is useful when a small table or report looks awkwardly pushed toward one edge of the paper. You can center it left to right, top to bottom, or both ways, while keeping the worksheet itself unchanged. Before printing, decide which cells should appear and whether the report should fit on one page; those choices affect what Excel centers.

What You’ll Need

  • An Excel workbook with the worksheet or report you want to print.
  • Excel for Microsoft 365 on Windows, or desktop Excel on Mac. The web version has fewer page setup controls; if you cannot find the centering checkboxes, open the workbook in the desktop app.
  • Optional: access to a printer, or simply use Print Preview to check the layout before printing.

Step-by-Step

  1. Select the worksheet you plan to print. Click its sheet tab at the bottom of Excel. If you intend to print a particular table, decide whether the rest of the sheet should be excluded. The centering options affect print layout, not the selected cell or the on-screen grid. If multiple sheets are selected, page setup changes can apply to all of them, so check that only the intended sheet tab is active.
  2. Set the print area if you only need part of the sheet. Select the cells you want on the page, then choose Page Layout > Print Area > Set Print Area. This prevents unrelated notes or formatting far away on the sheet from affecting the printout. If you want the entire used worksheet, skip this step. To remove an existing print area, choose Page Layout > Print Area > Clear Print Area; otherwise Excel may continue printing only the previously defined range.
  3. Open the custom margin controls. Go to Page Layout > Margins > Custom Margins. Excel opens the Page Setup dialog on the Margins tab. You can also open Page Setup by clicking the small dialog launcher at the bottom-right of the Page Setup group on the Page Layout tab. If the ribbon is collapsed, expand it or use the Margins menu. The standard Normal, Wide, and Narrow margin presets alone do not turn on page centering; you need the checkboxes in the custom dialog.
  4. Choose how the content should be centered. Find Center on page near the bottom of the Margins tab. Select Horizontally to place the printed content midway between the left and right margins. Select Vertically to place it midway between the top and bottom margins. Select both for a small report that should sit in the middle of the page. Leave a box unchecked if you want the content aligned toward that edge instead. These choices do not change the page margins or alter cell values.
  5. Review margins and the paper setup. While the Page Setup dialog is open, check the left, right, top, and bottom margin values. A printer may not be able to print all the way to the paper edge, so very small margins can be adjusted or ignored by the printer. Check the paper size and orientation as well: for example, a wide table may need landscape orientation. Centering works within the page layout Excel prepares, so the result can look off-center on paper if the printer uses different paper or has larger unprintable edges.
  6. Confirm the settings and inspect Print Preview. Click OK, then choose File > Print. Use the preview pane and page navigation arrows to inspect every page, not just the first. Check whether the content is centered as intended, whether headings and totals are included, and whether any columns or rows spill onto another page. The preview is the practical way to judge the print layout before using paper.
  7. Adjust scaling or page breaks if needed. If the table takes up multiple pages but should fit on one, return to the worksheet and use the Page Layout tab’s Scale to Fit settings, or open Page Setup and adjust scaling. You can set width and height to one page, but doing so may shrink text. If the printout already fits well across several pages, avoid forcing it to one page just to center it. Reopen Custom Margins to change the centering selection, then revisit Print Preview.
  8. Print only after the preview looks right. In File > Print, confirm the selected printer, paper size, orientation, and page range. Choose Print when the preview matches what you need. If you only want a digital check, you can stop at preview; there is no need to print a test copy. The centering options remain saved with the worksheet’s page setup, so you can return to them later.

On a Mac: The names and arrangement can differ slightly by Excel version. In desktop Excel for Mac, use the Page Layout tab’s margin controls or open File > Page Setup, then look on the Margins tab for the horizontal and vertical centering options. In Excel for the web, open the file in desktop Excel if the Center on page checkboxes are unavailable.

Common Mistakes

  • Expecting the worksheet view to move. The setting changes the printed layout only. It will not center the cells inside the Excel window, shift a table in the grid, or reposition the active cell.
  • Centering the wrong content. An existing print area may exclude the table you expect, or include extra blank-looking columns and rows. Check Page Layout > Print Area and inspect the preview to confirm exactly what Excel is printing.
  • Assuming centering means scaling. Center on page does not enlarge or shrink the report to fill the paper. It positions the print content within the page layout. Use Scale to Fit separately if you need to change how many pages the sheet occupies.
  • Forgetting that a multi-page report can still look uneven. A long sheet may have different amounts of content on different pages, and page breaks can divide sections. Preview each page and adjust page breaks or scaling if the printed report needs a more consistent appearance.
  • Ignoring printer margins or paper size. Excel’s preview can differ from the final output if the printer driver is set to a different paper size, or the printer cannot print near an edge. Verify the printer and paper settings before concluding that the centering option failed.
  • Changing settings on several selected sheets by accident. Grouped sheet tabs can cause layout edits to affect multiple worksheets. If sheet tabs are highlighted together, right-click a tab and choose Ungroup Sheets before changing page setup for just one sheet.

Tips

  • Use horizontal centering for most tables. A table that is narrower than the printable width often looks balanced when centered horizontally, while leaving vertical centering off keeps its heading near the top.
  • Use both directions for a small form or one-page summary. This can make a compact report look deliberate on a full sheet of paper. If it has a title, make sure vertical centering does not place the title too low for your intended use.
  • Choose the print area before centering. Excel can only lay out what is designated for printing. Setting the range first gives you a clearer preview and avoids centering an unintended set of cells.
  • Try orientation before shrinking text. A wide table may fit more comfortably in landscape orientation. Set this through Page Layout > Orientation > Landscape, then review preview before applying aggressive scaling.
  • Keep a visual check for headers and footers. Page numbers, dates, and custom headers or footers may occupy space or appear visually separate from the worksheet cells. If the sheet seems off-center, check the whole page preview, not only the table.
  • Use Print Preview as part of the process. The grid view is not a reliable indicator of printed placement. Preview helps reveal margins, page breaks, clipped columns, repeated titles, and unexpected blank pages before you print.

Troubleshooting

The printed table still looks off-center. Reopen Page Layout > Margins > Custom Margins and verify the right checkbox is selected. Then confirm the print area, paper size, orientation, and printer selection. Some printers have larger nonprintable areas on one side, so the physical sheet may not match the apparent center of the page in Excel’s preview. If necessary, adjust margins modestly and print or save a preview again.

The centering checkboxes are missing. Make sure you are using desktop Excel and are in the Page Setup dialog’s Margins tab, rather than looking only at the margin presets. On Mac, the dialog may be opened from File > Page Setup. Excel for the web may not expose every desktop page setup control; open the workbook in Excel for Windows or Mac to use the dedicated checkboxes.

Only part of the worksheet appears, or extra pages appear. Check for an old print area with Page Layout > Print Area > Clear Print Area, then define the desired range again if needed. In Print Preview, use the arrows to inspect all pages. Also look for manually inserted page breaks and content or formatting extending beyond the intended table. Centering cannot remove extra printed content.

The page is centered but the text is too small. Centering does not control text size. If you set the sheet to fit one page wide and one page tall, Excel may reduce it substantially. Try landscape orientation, a larger paper size if appropriate, or a wider print area; alternatively, allow the report to span more pages. Check the preview at readable zoom before printing.

Changes affect another worksheet too. The worksheets may be grouped. Look at the sheet tabs: if more than one is selected, right-click a selected tab and choose Ungroup Sheets. Select the single worksheet you want to format and set its margins again.

Frequently Asked Questions

How do I center a worksheet horizontally on a printed page?
Open Page Layout > Margins > Custom Margins and check Horizontally under Center on page. Click OK and check File > Print.

How do I center content vertically on the page?
In the same Margins tab, select Vertically. Select both boxes if you want the print content centered horizontally and vertically.

Does this center cells on the screen?
No. It changes print positioning only. To move a table on the worksheet itself, you would need to reposition its cells or change the worksheet view; the print centering checkboxes do neither.

Can I center just one table instead of the whole sheet?
Yes. Select the table and choose Page Layout > Print Area > Set Print Area before setting the centering options. Preview the output to verify that no unwanted cells are included.

Will centering make my report fit on one page?
No. Centering positions the content but does not change its size or page count. Use Scale to Fit or adjust page breaks if you need a different page count, then check whether the resulting text remains readable.

Why does the printed page look different from the preview?
Printer margins, paper size, orientation, and driver settings can change the output. Confirm those settings in File > Print and in the printer’s properties, and make sure the physical paper matches the selected size.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.