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. Check the result in File > Print. These settings center the printed content; they do not move cells or objects to the center of the worksheet on screen.
Excel positions printed content within the page’s printable area, taking margins and scaling into account. The result can be a centered table, report, or other worksheet content with more balanced white space. Before changing settings, decide which cells should print and confirm the paper size and orientation. That prevents Excel from centering an unintended range or scaling it unexpectedly.
What You’ll Need
- Excel for Microsoft 365 on Windows, with the workbook open. The steps use Excel’s desktop Page Layout and Print settings.
- A printer, or access to a print preview. You can use Microsoft Print to PDF or another PDF printer to check the layout without using paper.
- A worksheet with the content you want to print. If you only want part of the sheet, identify that range before you begin.
Step-by-Step
- Open the correct worksheet. Click the worksheet tab that contains the material you want centered. If the workbook has several tabs, check that you are not about to set up or print a different sheet. Page setup options generally apply to the active worksheet; if you have grouped multiple sheet tabs, ungroup them first unless you intend to apply the same layout to all of them.
- Choose the cells to print, if needed. If the whole sheet contains only the report, you can leave the print area unset. To print just a particular table or block, select its cells, then choose Page Layout > Print Area > Set Print Area. Excel will use that range as the printed content. To remove a previous selection later, choose Page Layout > Print Area > Clear Print Area. A print area is useful because blank or unrelated cells can otherwise make the printout appear off-center.
- Check the paper size and orientation. On the Page Layout tab, review Size and choose the paper size your printer or PDF output will use, such as Letter or A4. Use Orientation to choose Portrait or Landscape. A wide table may fit and look more balanced in landscape; a short, narrow report may suit portrait. Centering cannot compensate for a paper size that does not match the one selected in the print dialog or printer.
- Open the custom margin settings. Go to Page Layout > Margins > Custom Margins. Excel opens the Page Setup dialog on its Margins tab. You can also open the Page Setup dialog by clicking the small dialog box launcher in the lower-right corner of the Page Setup group, then selecting Margins. Either route leads to the same centering controls.
- Select the direction of centering. Find Center on page in the Margins tab. Check Horizontally to place the printed range midway between the left and right margins. Check Vertically to place it midway between the top and bottom margins. Select both boxes when you want the content centered in both directions. Leave one box unchecked if you want to center only along the other axis.
- Review the margin values. The top, bottom, left, and right margins define the printable area in which Excel centers the content. If the values are unusually large, or if the printer has a non-printable border, Excel may have less room than expected. You can keep the default margins or enter appropriate values in the margin boxes. The centering option does not eliminate printer limits or make content extend to the edge of the paper.
- Confirm the settings. Click OK to close Page Setup. The worksheet view may not look different: the center-on-page options affect the printed layout, not the location of the cells in the grid. Do not judge the result only from the normal worksheet view.
- Inspect Print Preview. Choose File > Print, or press Ctrl+P on Windows. Check the preview page for horizontal and vertical placement, clipping, blank pages, and readability. If the content is not centered, verify the selected print area, the active worksheet, the page orientation, and the center-on-page boxes. Make any changes through Page Layout and return to Print Preview to check again.
- Print or save a PDF. When the preview looks right, choose the printer and print. For a digital copy, select a PDF printer, such as Microsoft Print to PDF, if available, and complete the save prompts. Recheck the preview after changing printers or paper sizes because the printable margins can vary between devices.
To center content vertically only: select just Vertically. This is often useful for a short report on a page. To center a wide table from left to right while keeping it near the top, select only Horizontally. The two checkboxes work independently, so there is no need to change the cell alignment or add blank rows and columns.
Common Mistakes
- Confusing print centering with cell alignment. Home tab alignment buttons position text inside its cells. They do not center the printed range on paper. Use the Page Setup margins option for page centering.
- Printing the wrong range. A leftover print area can exclude part of a report or include an unexpected range. Clear it or set the correct range before previewing.
- Expecting worksheet cells to move. The center setting changes print layout only. It does not rearrange a table in the grid, change cell positions, or center the worksheet in the Excel window.
- Using scaling to solve every layout problem. Fit Sheet on One Page can shrink a large worksheet until text is difficult to read. First choose a sensible print area, paper size, and orientation. Then inspect the scale and use a multi-page layout if necessary.
- Ignoring margins and printer limits. The visual center is based on the printable page area, not necessarily the paper’s physical edges. Different printers can have different non-printable regions.
Tips
- Use preview as the final check. The worksheet grid is designed for editing and is not a reliable picture of the printed page. Print Preview shows the page breaks, scaling, and placement that matter.
- Center only the direction you need. Horizontal centering is useful for a table that should sit evenly between side margins. Vertical centering can balance a short form or title page. Using both is suitable when the content should sit in the middle of the available page area.
- Keep the selected range tight. If the print area includes many empty columns or rows, Excel centers that larger area, not just the visible table. Select the intended content and set its print area rather than including extra blank cells.
- Make wide reports readable. Consider landscape orientation or printing the report across multiple pages before shrinking it. If you do use scaling, check that labels and numbers remain legible in the preview or PDF.
- Remember that page setup is per worksheet. If you print several worksheets, check each one’s print area and page setup. Do not assume a centering choice on one tab has automatically been applied to every tab in the workbook.
- Use a test PDF for repeatable reports. A PDF lets you inspect alignment and page breaks before printing. If the PDF looks different after choosing a different paper size or printer, revisit Page Setup and check the preview again.
Troubleshooting
The content still looks left-aligned. Return to Page Layout > Margins > Custom Margins and check Horizontally. Then check that the printed range is the one you intended. A very wide print area, even if most of it is empty, can make the visible table seem displaced because Excel centers the entire area.
The content is not centered top to bottom. Check Vertically in the same dialog. Also review the top and bottom margins and look at the full page in Print Preview. If the range spans several pages, vertical centering applies within the printed page layout; it will not turn a multi-page report into one compact block.
The table is clipped or tiny. Centering controls position, not size. Set the correct print area, change portrait to landscape if appropriate, and review Page Layout > Scale to Fit. Avoid forcing a large range onto one page if the resulting text is unreadable. A print area with too many blank cells can also cause unwanted scaling.
The preview shows unexpected blank pages. Check for a print area that extends beyond the report, stray formatting far from the data, or manual page breaks. Clear and reset the print area if needed, then review View > Page Break Preview to see how Excel divides the sheet. Return to View > Normal when finished.
The printed copy differs from the preview. Confirm the printer’s paper size and orientation match Excel’s settings. Some printers impose larger unprintable margins than others. Try saving to PDF to separate a layout issue from a printer-specific issue, and confirm that the selected printer has not changed the paper settings.
You are using Excel for Mac or Excel for the web. In Excel for Mac, use the Page Layout tab and look under Margins for the custom margin and centering options; dialog labels and placement may vary slightly by release. Keyboard shortcuts differ on Mac: Command+P opens printing rather than Windows Ctrl+P. Excel for the web has more limited page setup controls, and available print options can vary. If you cannot find the center-on-page checkboxes, open the workbook in the Excel desktop app and set them there.
Frequently Asked Questions
How do I center a worksheet on a printed page in Excel?
Choose Page Layout > Margins > Custom Margins, then select Horizontally, Vertically, or both under Center on page. Use File > Print to inspect the result.
Can I center a table horizontally but keep it at the top?
Yes. Select Horizontally and leave Vertically unchecked. The table will be centered between the side margins without being moved to the vertical middle of the page.
Does centering on the page change the cells in my worksheet?
No. It changes how Excel places the printed content. It does not change cell alignment, resize columns, or move the worksheet data in the grid.
Can I center only part of a worksheet?
Yes. Select the desired cells and choose Page Layout > Print Area > Set Print Area before setting the margins. Excel will center that print area rather than the entire used range.
Why is my printout not exactly centered on the sheet of paper?
Excel centers within the printable area defined by the margins, and printers can have uneven or non-printable edges. Check the printer’s paper settings and compare the print preview with a PDF. The physical result can differ slightly between printers.
Can I center a chart or picture this way?
When a chart or picture is part of the worksheet’s printed content, include it in the area being printed and inspect the preview. The center-on-page option positions the page’s printable content; it is not a command for moving an object to the center of the worksheet grid. For a chart that should print by itself, use its own chart-sheet or print settings and check its preview.
Related
- How to Auto Capitalize Names in Excel Using PROPER
- Append Data in Excel with Power Query: A Step-by-Step Guide
- How to Align Text in Excel Without Merging Cells
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add Page Numbers in Microsoft Word: A Practical GuideTo add page numbers in Microsoft Word for Microsoft 365 on Windows, select Insert > Page Number, choose…
- How to Freeze Column Width in Excel and Stop ResizingTo keep a column’s width from being changed in Excel, set the width first, then protect the worksheet…
- Excel Cell Size in CM: What the Measurements MeanExcel does not give every cell a single size in centimeters. A cell’s width comes from its column-width…
- Named Range Sheets: How Excel Scope WorksIn Excel, a named range is a label for a cell or range, and its scope determines whether…
- How to Copy Down in Excel with the Fill Handle or ShortcutTo copy down in Excel, enter or select the content in the top cell, select the cells below…
- How to Split a Cell in Microsoft ExcelTo split the contents of a cell into separate columns in Microsoft Excel, select the cells, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.