To center an Excel worksheet on a printed page in Microsoft Excel for Microsoft 365 on Windows, open Page Layout > Margins > Custom Margins. In the Page Setup window, select Horizontally, Vertically, or both under Center on page, then click OK. Check the result in Print Preview before printing. These settings change the printed layout, not the position of cells on the worksheet.
Centering is useful when a small table or report looks lopsided because it sits at the left or top of a sheet of paper. You can align it across the page, down the page, or both ways. First decide what content should print; if necessary, set a print area so Excel centers only the intended range.
What You’ll Need
- An Excel workbook with the worksheet you want to print.
- A printer, or the option to save or print to PDF, if you want a physical or digital printout.
- The desktop version of Excel for the full centering controls. Excel for the web may not show the Center on page checkboxes; open the workbook in the desktop app if they are unavailable.
Step-by-Step
- Open the worksheet you plan to print. Click its sheet tab at the bottom of the workbook. If you have several worksheets, work on one at a time unless you deliberately want to apply the same page settings to multiple selected sheets. Centering affects print layout for a worksheet; it does not move the data or change cell alignment.
- Decide which cells belong on the printed page. Look for stray notes, formatting, or content far from the main table that could expand the print range. If you want to print a defined section, select its cells, then choose Page Layout > Print Area > Set Print Area. Excel will use that print area for the print layout, including centering. To remove an existing print area, choose Page Layout > Print Area > Clear Print Area. Skip this step if the default print range is already right.
- Open the custom margin settings. On the ribbon, select Page Layout > Margins > Custom Margins. This opens the Page Setup window on its Margins tab. Another route is to select the small dialog box launcher in the bottom-right corner of the Page Setup group on the Page Layout tab, then choose the Margins tab if needed.
- Choose the kind of centering you need. In the Margins tab, find Center on page. Check Horizontally to position the print content midway between the left and right margins. Check Vertically to position it midway between the top and bottom margins. Select both boxes to center the content in both directions. You can select just one, so the worksheet remains aligned to the top or left while being centered along the other axis.
- Review the margin values and click OK. The left and right margins, and the top and bottom margins, define the printable space in which Excel lays out the content. You can leave the existing margins in place, or adjust them in the same dialog if they are unsuitable for the paper or printer. Click OK to apply the settings. If Excel warns that margins are outside the printable area, choose an available adjustment or use margins your printer supports.
- Check Print Preview. Press Ctrl+P on Windows, or use File > Print, to open the print screen and preview. Confirm that the content appears centered in the page area and that the intended rows and columns are visible. Use the next-page controls if the worksheet spans multiple pages; centering applies to the page layout, so inspect every page rather than checking only the first.
- Adjust other print settings only if needed. If the content is centered but too large, too small, or split awkwardly, return to the worksheet and review paper size, orientation, margins, and scaling. On the Page Layout tab, the Scale to Fit controls can fit a sheet to a chosen number of pages, but scaling is separate from centering. Preview again after each change. When the layout is right, print or save as a PDF.
On Excel for Mac, select the worksheet and use the Page Layout tab, then Margins > Custom Margins. In the Page Setup dialog, use the Margins tab and the Horizontally and Vertically options under Center on page, then confirm and preview. Ribbon wording or placement can vary slightly by release. Excel for the web has a more limited set of page setup features; if you cannot find these checkboxes, open the file in desktop Excel rather than looking for a worksheet-cell alignment command.
Common Mistakes
- Centering cells instead of the printed page. The Center alignment button on the Home tab changes how text sits inside selected cells. It does not center the worksheet when printed. Use the Center on page checkboxes in the Page Setup Margins tab.
- Checking only one direction by accident. Horizontal centering does not move the content down the page, and vertical centering does not move it toward the middle from left to right. Select both options if you want the content centered on both axes.
- Leaving a large or incorrect print area. A stray cell far away from the table can make Excel treat a much bigger region as the content to lay out. The table may then look off-center or tiny. Set or clear the print area, and inspect the preview for unexpected blank pages.
- Expecting centering to resize the worksheet. The setting changes placement, not the number of pages or the scale of the text. Use print scaling separately if content must fit on fewer pages, and check that the resulting text remains readable.
- Assuming the setting changes every worksheet. Page setup is associated with worksheet print settings. Check each sheet you plan to print, and verify that you have not selected or grouped sheets unintentionally before changing settings.
Tips
- Choose the print area before centering. Centering applies to the content Excel is preparing to print. Defining the intended range first makes the preview easier to assess and avoids centering a large, mostly empty used range.
- Use horizontal centering for wide tables and both options for short reports. A multi-page table may look best centered left-to-right while remaining near the top of each page. A compact one-page summary may benefit from vertical as well as horizontal centering.
- Consider paper orientation and margins. A wide table may need landscape orientation, while a narrow report may suit portrait. These settings affect the available page space, so choose them before making a final judgment about alignment.
- Preview at the paper size you will use. A layout that looks balanced on one paper size may shift or wrap differently on another. In the print screen, confirm the paper size, printer, orientation, and page count along with the centering.
- Save after you are satisfied. Page setup choices are saved with the workbook. Saving preserves them for the next time you open and print it, though a different printer can have different printable margins.
Troubleshooting
The page still looks left-aligned or top-aligned. Reopen Page Layout > Margins > Custom Margins and confirm that the intended checkbox is selected. Then click OK and reopen Print Preview. Make sure you are previewing the same worksheet whose settings you changed, and check whether a different sheet is selected in the print options.
The table is centered but sits in a surprising place. Check the left and right margins for horizontal placement, or the top and bottom margins for vertical placement. Unequal margin values can make the center of the printable area differ from the visual center of the paper. Also check for headers or footers, which use their own settings and can affect the overall appearance, and confirm that the print area contains only the intended cells.
The content is centered but split across too many pages. Centering does not fit content to a page. Review the page breaks and print scaling separately. You can use the Scale to Fit options on the Page Layout tab, or adjust the print area, orientation, and paper size. Avoid shrinking a large worksheet so much that labels become difficult to read; sometimes printing across multiple pages is clearer.
Some columns or rows are missing. Check whether the print area excludes them, whether they are hidden, and whether the preview is showing another page. Clear the print area and preview again if you are unsure. Also inspect page breaks and scaling settings; centering cannot bring excluded cells onto the page.
You cannot find Center on page. In desktop Excel, open the Custom Margins dialog from the Page Layout tab and look on its Margins tab. If you are using Excel for the web and the options are not available, choose the command to open the workbook in the desktop app. On Mac, look under Page Layout and Margins; the dialog may be arranged differently from Windows.
Frequently Asked Questions
Can I center an Excel sheet horizontally but not vertically?
Yes. In the Page Setup Margins tab, select Horizontally and leave Vertically unchecked. The printed content will be centered from left to right but will retain its top-to-bottom placement within the margins.
How do I center a spreadsheet both horizontally and vertically?
Open Page Layout > Margins > Custom Margins, select both options under Center on page, and click OK. Check the print preview to confirm how the content sits on the selected paper size.
Does this move the cells in my worksheet?
No. It changes where Excel places the printable content on the page. Cell positions, formulas, and on-screen alignment remain unchanged. To center text inside cells, use the alignment controls on the Home tab instead.
Can I center only a selected range?
Yes. Select the range and choose Page Layout > Print Area > Set Print Area before turning on centering. Preview the page to confirm that Excel is printing the intended range. Clear the print area when you want to return to the default print range.
Will the setting apply to every sheet in my workbook?
Not automatically in every case. Apply and check the page setup for each worksheet you intend to print. If you group sheets to change settings together, ungroup them afterward by right-clicking a selected sheet tab and choosing Ungroup Sheets.
Can I center a sheet in Excel for the web?
The web app may not include the desktop Center on page options. If the checkboxes are missing, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac, set the options in Page Setup, and then preview or print.
Related
- Forecast in Excel: How to Build a Reliable Prediction
- Ungroup in Excel: How to Bring Back the Ungroup Command
- How to Average Data in Excel Across Different Sheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Table Not Adding New Rows? Causes and SolutionsExcel tables usually add rows when you type directly in the first row beneath them, or press Tab…
- How to View Track Changes in a Word Document ClearlyTo view tracked edits in Word, open the document, select Review > Display for Review (in the Tracking…
- Conditional Formatting for Errors in Excel: How to Do ItTo highlight error cells in Excel, select the range, choose Home > Conditional Formatting > New Rule >…
- Create an Outlook Email Signature: Step-by-Step GuideTo create an Outlook signature, open the signature settings for your version of Outlook, write and format your…
- Excel Hide Columns Toggle Button: Options That WorkExcel for Microsoft 365 on Windows does not include a built-in ribbon button that alternates between hiding and…
- Excel Date Slicer by Month: Setup and TroubleshootingYes. In Excel for Microsoft 365 on Windows, create a PivotTable, group its date field by months, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.