To center selected cells on a printed page in Excel for Microsoft 365 on Windows, select the range, choose Page Layout > Print Area > Set Print Area, open the Page Setup dialog, and on the Margins tab check Center on page horizontally, vertically, or both. Preview the result with File > Print before printing. This positions the print area within the printable space; it does not center the text inside the cells.
What You’ll Need
- A desktop version of Excel, such as Excel for Microsoft 365 on Windows. The desktop app provides the Page Setup controls used in this guide.
- A worksheet with the cells you want to print. Decide whether you want to print the entire sheet or just a selected range.
- A printer, or access to File > Print to inspect the preview without printing. You can also save to PDF from the print screen if you want a digital copy.
It helps to know the intended paper size and orientation first. Centering changes the position of the printout, while paper size, margins, and scaling determine how much room the content has. If the sheet is too wide or long to fit, centering alone will not make it fit on one page.
Step-by-Step
- Open the worksheet and identify the range. Go to the sheet you plan to print. If you want only part of it, identify the first and last cells of the block, including any headings, totals, or notes that need to appear. For instance, a report running from A1 to F28 should include the title and column headings if they belong on the printout. Avoid selecting unrelated blank rows or columns, because they can enlarge the print area and affect the preview.
- Select the cells you want printed. Click the first cell, then drag to the last cell, or click the first cell and Shift-click the last. For a range you can identify by address, click the Name Box to the left of the formula bar, type a range such as A1:F28, and press Enter. Confirm that the selection outline covers the whole report and no extra cells.
- Set the selection as the print area. On the ribbon, choose Page Layout > Print Area > Set Print Area. Excel will use that range as the printable content for the active worksheet. Setting this is important: the Center on page option positions the sheet’s print area, so merely highlighting cells without making a print area may leave Excel printing other used cells as well.
- Open the page setup controls. Stay on the Page Layout tab. In the Page Setup group, click the small dialog box launcher at the group’s lower-right corner. The Page Setup window opens. If the ribbon is compressed and the launcher is not obvious, expand the ribbon or open the Page Layout tab and look for the small diagonal arrow in Page Setup.
- Choose how to center the printout. In Page Setup, select the Margins tab. Under Center on page, select Horizontally to center the print area from left to right, Vertically to center it from top to bottom, or both boxes to center it in both directions. Click OK to apply the settings. Horizontal centering is often useful for a narrow table; vertical centering can help a short form or title page look balanced.
- Check the paper layout and scaling. If needed, use Page Layout > Orientation to choose Portrait or Landscape and Page Layout > Size to select the paper size. In the Scale to Fit group, review Width and Height. For example, setting Width to 1 page can fit a wide report across one page, but may shrink the text. Centering will position the scaled output; it does not choose a readable scale for you.
- Preview before printing. Choose File > Print. Review the preview for the correct print area, page count, paper size, orientation, margins, and legibility. If the content is not where expected, return to the worksheet or Page Setup, adjust the setting, and reopen the preview. When it looks right, select the printer and print, or choose a PDF printer or PDF option if available to save a copy.
On a Mac, the Page Setup controls are also available from the Page Layout tab; depending on the Excel release, open them through Page Layout > Margins > Custom Margins, then use the Margins tab and Center on page options. Excel for the web has fewer page setup controls, and the desktop app is the more reliable choice for setting and checking this layout. Menu labels can vary slightly between releases.
Common Mistakes
Confusing page centering with cell alignment. Home > Center aligns the text or numbers inside selected cells. It does not move the printed block to the middle of the paper. Use the Page Setup Margins tab for page centering. You can use both features, but they solve different problems.
Forgetting to set the print area. A highlighted range is not necessarily the range Excel prints. If the worksheet has other content elsewhere, the print preview may include it or create extra pages. Set the print area explicitly, then verify it in File > Print.
Centering a range that includes blank space. Empty rows or columns inside the selected print area still take up space. If the report seems off-center or small, check the selection boundaries and remove unnecessary blank cells by setting a tighter print area.
Using scaling to solve a position problem. Fit to one page changes the size of the content; Center on page changes its position. If the printout is tiny, adjust scaling, page orientation, or paper size rather than expecting centering to enlarge it.
Assuming the preview matches the printer automatically. The selected printer can impose its own printable margins or paper defaults. A preview made for one paper size or printer may differ from the final output on another. Check the printer and paper settings before printing.
Tips
Use horizontal centering by itself when the report should sit in the middle from side to side but start near the top. This is a common choice for tables with several columns. Use both directions for a short, self-contained form or a small chart that should appear near the center of a single page. Vertical centering is less useful for long reports because it can leave the top of the page looking unexpectedly empty.
For a one-page report, choose the print area first, then settle the paper size, orientation, and scaling, and finally judge the centering in Print Preview. That order makes it easier to see whether the actual problem is position, fit, or an incorrect range. If you change the selected range later, reset the print area using Page Layout > Print Area > Set Print Area and check the preview again.
Use Page Layout > Margins to pick a preset such as Normal, Narrow, or Wide, or choose Custom Margins to enter specific values. The printable area is the space left after margins are applied, so different left and right margins can make a centered printout look shifted relative to the physical sheet. If visual balance matters, use matching side margins and inspect the preview.
If a worksheet contains multiple unrelated blocks, consider printing them separately rather than selecting distant areas at once. Nonadjacent print selections can produce separate print areas and unexpected page breaks. A clear print area and a deliberate page break plan are usually easier to maintain than one large selection with broad empty gaps.
Troubleshooting
The printout is still aligned to the left or top. Reopen Page Layout’s Page Setup dialog and confirm the intended Center on page boxes are checked on the Margins tab. Make sure you changed the settings for the worksheet you are printing; page setup is worksheet-specific. Then reopen File > Print to refresh the preview.
Extra pages appear. Go back to the sheet and check whether the print area includes stray cells, blank columns, or objects beyond the report. Choose Page Layout > Print Area > Clear Print Area to remove the existing boundary, select the intended block, and set it again. Also inspect Width and Height in Scale to Fit and use Page Layout > Breaks if page breaks are splitting the content unexpectedly.
The content is centered but too small. Centering is working, but scaling may be shrinking the range to fit. In Page Layout’s Scale to Fit group, check whether Width or Height is set to 1 page. If the text is hard to read, allow the printout to use more pages, switch to Landscape, reduce unnecessary columns, or use larger paper. Preview after each change.
The preview looks centered but the printed sheet does not. Check the printer’s paper size, orientation, and margin settings in the print dialog or printer properties. Confirm that the tray contains the selected paper. Some printers cannot print to the edge, and their unprintable regions can make the visible result appear off-center even when Excel centers within its printable area.
The page setup controls are missing. In Excel for Windows, use the desktop app and expand the Page Layout ribbon if needed. In Excel for the web, open the workbook in the desktop app for the full Page Setup options. On Mac, look under Page Layout and open Custom Margins to find the centering controls. If a workbook is protected or opened read-only, you may also need permission to change its layout.
Frequently Asked Questions
Can I center the printout horizontally without centering it vertically?
Yes. In Page Setup > Margins, check Horizontally and leave Vertically unchecked. The print area will be centered across the printable width while retaining its normal top position.
Does Center on page center the words inside each cell?
No. It centers the printed range on the page. To center cell contents, select the cells and use Home > Center. For both effects, apply cell alignment and page centering separately.
Do I have to set a print area before using this option?
No, not if you intend to print the entire worksheet. But setting a print area is recommended when only a selected block should print, especially if other content exists elsewhere on the sheet.
Will centering make my worksheet fit on one page?
No. Centering changes placement, not the number of pages. Use the Scale to Fit controls or adjust orientation, paper size, and margins to change how content fits, then check that the resulting text remains readable.
Can I center a printout on every worksheet in a workbook at once?
Page setup is stored for each worksheet. You can group worksheet tabs to apply some layout changes to multiple sheets, but first confirm that the sheets have compatible print areas and layouts. Ungroup the tabs afterward so later edits do not affect all grouped sheets unintentionally.
Why does the preview look slightly off-center on the physical page?
Excel centers within the printable area defined by the margins, not necessarily between the paper’s edges. Unequal margins, printer limitations, or a mismatched paper setting can create a visual offset. Check Custom Margins and the printer’s selected paper size.
Related
- How to Add Serial Numbers in Excel Automatically
- How to Add Page Numbers in Excel
- How to Add a Row in Excel: Shortcuts for Windows and Mac
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Power Query: Compare Two Columns Step by StepIn Excel Power Query, compare values on the same row by opening Add Column > Custom Column and…
- How to Add a New Section to a Word Table of ContentsTo add a new section to a table of contents in Microsoft Word, format the section title with…
- How to Make a Trifold Brochure in Microsoft WordTo make a trifold brochure in Word, set a page to landscape, divide it into three columns, and…
- How to Find Duplicate Entries in ExcelTo find duplicate entries in Excel, select the cells you want to check, then choose Home > Conditional…
- How to Copy an Entire Row in ExcelTo copy an entire row in Excel for Microsoft 365 on Windows, click the row number at the…
- Freeze Multiple Columns in Excel: A Step-by-Step GuideTo freeze multiple columns in Excel for Microsoft 365 on Windows, select the cell immediately to the right…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.