To center a worksheet on a printed page in Excel for Microsoft 365 on Windows, open Page Layout > Margins > Custom Margins, select Horizontally and/or Vertically under Center on page, then check the result in File > Print. This positions the printable worksheet content between the page margins; it does not center the text inside cells. Before changing the settings, decide which cells you want to print and whether the worksheet should be centered left to right, top to bottom, or both.
What You’ll Need
- An Excel workbook open in the desktop version of Microsoft Excel for Microsoft 365 on Windows. The centering controls are also available in desktop Excel for Mac, though dialog placement can vary slightly.
- A worksheet with the data or chart you intend to print. If the sheet contains notes or unrelated content, identify the intended print range first.
- A printer is helpful for checking the final output, but it is not required. Excel’s Print preview can show the page layout without sending anything to a printer.
Step-by-Step
- Choose the worksheet and check what is on it. Click the sheet tab containing the content you want to print. Look for stray values, formatting, or objects far beyond the main table: Excel can treat distant content as part of the used area and make the actual table appear small or off-center. If the worksheet contains several unrelated sections, decide whether you want all of them or just one area on the printed page.
- Set a print area if you only want part of the sheet. Select the cells that should appear on paper, then choose Page Layout > Print Area > Set Print Area. This is optional when the whole worksheet is intended for printing. To remove a print area later, choose Page Layout > Print Area > Clear Print Area. Defining the area first helps Excel center the intended range rather than an unnecessarily large portion of the sheet.
- Open the page margin settings. On the ribbon, select Page Layout > Margins > Custom Margins. Excel opens the Page Setup dialog on its Margins tab. You can also open Page Setup from the small dialog launcher in the lower-right corner of the Page Setup group on the Page Layout tab. If the ribbon is collapsed, expand it or use the tab to reveal the group.
- Choose horizontal centering, vertical centering, or both. In the Page Setup dialog, find the Center on page section. Select Horizontally to center the printed range between the left and right margins. Select Vertically to center it between the top and bottom margins. Select both options if you want the content centered in both directions. Leave one unchecked when you want the content aligned toward that edge of the printable area.
- Review the margin values. The centering options work within the margins, not from the physical edge of the paper. You can keep the preset margins or adjust the Top, Bottom, Left, and Right values in the same dialog. Avoid making margins smaller than your printer can handle; a printer may clip content in its unprintable edge area even if Excel’s preview looks acceptable.
- Confirm the settings and inspect Print preview. Click OK, then choose File > Print. Review the preview on the right side of the print screen. Check that the content is centered relative to the page, that the correct range is included, and that no columns or rows have been cut off. Use the page navigation controls if the printout spans more than one page.
- Adjust the page layout if the content still looks unbalanced. If the range is too wide, choose a suitable orientation from Page Layout > Orientation, such as Landscape. If it is too large to fit, use the Scale to Fit options on the Page Layout tab or select a scaling choice in the print settings. Scaling changes the size of the printed content; centering changes its position. Check both because either can affect the visual result.
- Print only after the preview is right. When the preview shows the intended content at an appropriate size and position, choose the printer and copies, then select Print. If you change the print area, margins, orientation, or scaling afterward, return to Print preview before printing again. Those settings can interact, so a page that looked right before a change may need another review.
On a Mac: In desktop Excel for Mac, select the worksheet and use Page Layout > Margins > Custom Margins, then enable the horizontal or vertical centering option in Page Setup. Ribbon labels or dialog placement can differ by Excel release, but look for the Center on page choices in the page margins or Page Setup controls. In Excel for the web, the full desktop Page Setup controls may not be available; open the workbook in the desktop app to set page centering, then use the web print preview if needed.
Common Mistakes
- Using the cell alignment buttons instead. Home tab alignment controls position text inside selected cells. They do not center the worksheet on the printed sheet. Use the Center on page options in Page Setup for print positioning.
- Centering the entire sheet when only a table should print. Empty-looking cells with formatting or distant content can enlarge the area Excel considers. Set a deliberate print area and check the preview rather than assuming the visible table is the only content included.
- Expecting centering to resize the content. Center on page moves the printed range within the margins; it does not shrink a wide table or make it fit on one page. Use orientation or scaling when the issue is size, and preview the result so text does not become too small to read.
- Changing margins without checking printer limits. Very narrow margins can cause clipping or a different result on another printer. Keep a practical margin and use the preview as a guide, while remembering that the physical printer may have nonprintable edges.
- Checking only one of the two options by accident. Horizontal and vertical are independent. A sheet can be centered left to right but remain at the top, or centered top to bottom while aligned to the left. Confirm both checkboxes match the layout you want.
Tips
- Use one-direction centering when it suits the report. A wide table often looks best centered horizontally but positioned near the top of the page, leaving room below for notes or a signature. A short form may benefit from both horizontal and vertical centering.
- Set orientation before fine-tuning margins. Switching from Portrait to Landscape changes the available page width. Choose the likely orientation first, then assess whether the margins and centering look appropriate.
- Think about page breaks for long worksheets. Centering a print area does not combine several pages into one. If the worksheet spans multiple pages, use View > Page Break Preview to inspect where Excel divides it, and adjust page breaks or scaling only if the layout needs it.
- Use the preview at the actual page size. A table may appear centered but be too small to read after scaling. Zoom in on the preview or print a single test page when readability matters. Check headings and totals as well as the page edges.
- Remember that page settings belong to the worksheet. If a workbook has several sheets, configure and preview each sheet that needs a different printed layout. Selecting another tab does not necessarily apply the first sheet’s print area or margins to it.
Troubleshooting
The content still appears off-center. Reopen Page Layout > Margins > Custom Margins and verify that the correct centering option is checked. Then inspect the print area and preview. A print area that includes a stray column, a distant cell, or an object can make the intended table look displaced even when Excel is centering the full selected area correctly. Clear and reset the print area if necessary.
The worksheet is centered but clipped. Centering cannot fix content that extends beyond the printable width or height. Check whether the page is in Portrait or Landscape, reduce unnecessary margins only within your printer’s limits, or use a suitable scaling option. If the printout spans several pages, review page breaks and the print preview for each page rather than judging from the first page alone.
The content is centered in the preview but prints differently. Confirm the selected printer and paper size in the print screen. A printer configured for Letter paper may lay out content differently from one configured for A4, and printer hardware can impose nonprintable margins. Match Excel’s paper size to the paper loaded in the printer, then preview again. If the mismatch continues, check the printer’s own paper and scaling settings.
The centering checkbox or dialog is missing. Make sure you are using desktop Excel and have opened the Custom Margins or Page Setup dialog, not just the basic print screen. In Excel for the web, open the file in the desktop application for the full controls. On Mac, check the Page Layout margin or Page Setup options; the exact dialog arrangement can vary between releases.
Only one sheet changed. Page setup is configured per worksheet unless you deliberately group sheets. Select each sheet and set its own print area and centering, or group the intended sheets before making compatible layout changes. Be careful: while sheets are grouped, edits can affect every selected sheet. Ungroup them by clicking an unselected tab when you are finished.
Frequently Asked Questions
How do I center an Excel page horizontally only?
Open Page Layout > Margins > Custom Margins and select Horizontally under Center on page. Leave Vertically unchecked if the content should remain near the top of the page.
How do I center a worksheet both horizontally and vertically?
In the Custom Margins dialog, select both Horizontally and Vertically. Click OK and confirm the placement in File > Print preview.
Does center on page center the text in my cells?
No. It positions the print area on the paper. To center cell contents, select the cells and use the horizontal or vertical alignment controls on the Home tab.
Can I center a selected range instead of the whole worksheet?
Yes. Select the range and choose Page Layout > Print Area > Set Print Area before turning on page centering. Preview the output to verify that only the intended cells print.
Why does Excel split my centered table across pages?
Centering controls position, not page count. Change orientation, review the print area, or adjust scaling and page breaks. Check that the resulting text remains readable before printing.
Will the setting apply to every sheet in the workbook?
Usually it applies to the active worksheet. Set up other sheets individually, or group the sheets you want to configure together and take care to ungroup them afterward.
Related
- How to Align a Picture in an Excel Cell: Step by Step
- How to Align Names in Excel: Cells and Lists
- How to Align an Image in an Excel Cell and Keep It in Place
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Compare Two Columns in Excel for DifferencesTo compare two Excel columns row by row, put a comparison formula in a third column and fill…
- Embed a Google Drive Video in PowerPoint: What WorksYou can put a Google Drive video in a PowerPoint presentation, but PowerPoint does not natively play a…
- Excel Undo Shortcut: Keys, Limits, and How It WorksIn Excel for Microsoft 365 on Windows, press Ctrl+Z to undo your most recent action. On a Mac,…
- How to Delete a Second Page in a Word Document QuicklyTo delete a second page in Microsoft Word, first check whether it contains text or is blank. On…
- How to Freeze Panes in Excel: Keep Rows and ColumnsTo freeze panes in Excel for Microsoft 365 on Windows, select the cell immediately below the rows and…
- Excel Slicer: Connect One Slicer to Multiple PivotTablesYes. In Excel for Microsoft 365 on Windows, one slicer can filter multiple PivotTables when they share a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.