To center an Excel print area, open Page Layout > Margins > Custom Margins, then, on the Margins tab, select Horizontally, Vertically, or both under Center on page and click OK. Set the print area first if needed with Page Layout > Print Area > Set Print Area, then check the result in Print Preview.
Center a print area in Excel: the basic steps
These steps apply to Excel for Microsoft 365 on Windows. First select the cells you want printed, unless a print area is already defined. On the ribbon, choose Page Layout > Print Area > Set Print Area. Excel records that selection as the range to print; cells outside it are left out of the printout unless you change or clear the print area.
- Open Page Layout > Margins > Custom Margins.
- In the Page Setup window, locate the Center on page options on the Margins tab.
- Select Horizontally to center the output from left to right, Vertically to center it from top to bottom, or both for placement in the middle of the page.
- Click OK, then use File > Print or press Ctrl+P to inspect the preview before printing.
The centering options affect print layout, not the position of cells in the worksheet grid. They do not move data, change cell alignment, or add blank rows and columns to the sheet. If the result still looks off, check the print area, margins, scaling, and page breaks rather than moving the worksheet contents.
What the Center on page settings do
Excel lays out the printable worksheet content inside the page margins. Selecting Horizontally distributes the available space to center the content from side to side within that printable region. Selecting Vertically centers it between the top and bottom margins. The margins remain important: the center is based on the printable area defined by the margins, not necessarily the physical center of the sheet of paper.
For example, if a small report occupies columns B through F and rows 2 through 20, it may sit close to the upper-left corner of the page by default. Horizontal centering can make the report sit in the middle from left to right. Selecting both options also moves its printed position toward the vertical middle. The actual appearance depends on the paper size, printer’s printable area, margins, and any scaling applied.
Centering is useful for a compact summary, a one-page form, or a chart with a short heading. It is not always appropriate for a long table. A table that spans several pages may be easier to read when it begins near the top of each page, rather than being vertically centered with different amounts of empty space around its content.
Set or check the print area first
A print area determines which cells Excel includes in a print job. Centering does not choose the cells for you, so check this setting before adjusting alignment. If you select only part of a sheet and set it as the print area, Excel will center that part, not every used cell on the worksheet.
To define or replace the range, select the cells and choose Page Layout > Print Area > Set Print Area. To remove the defined range and return to printing the worksheet’s content, choose Page Layout > Print Area > Clear Print Area. Print Preview is a useful confirmation: if expected columns or rows are missing, the print area may exclude them. If unwanted blank pages appear, the print area or page breaks may extend farther than the visible report.
Excel can also have more than one print area on a worksheet. If you select separate, nonadjacent ranges and set them as print areas, Excel prints those areas separately rather than treating the gaps as part of one continuous rectangular report. That can produce an unexpected page count or layout. For a single centered block, a contiguous selection is usually simpler to manage.
Choose horizontal, vertical, or both
Choose the direction that solves the actual layout problem. Horizontal centering is often enough when a report is too far to one side but already begins at a sensible height. Vertical centering is useful for a short page, such as a cover sheet or a form that should not sit at the top. Selecting both is suitable when a small print area should be centered in both directions.
- Horizontally: centers the printed content from left to right. Try it for a narrow table or chart on a landscape page.
- Vertically: centers the content from top to bottom. Try it for a short report with substantial unused space below.
- Both: centers the output in both directions. This can work well for a one-page title sheet, but may leave large blank areas around a small table.
For example, a five-column monthly summary on portrait paper may look better with horizontal centering only. A one-page sign-up form with just a few rows may benefit from both settings. A detailed inventory extending across several pages is usually better left top-aligned vertically so the first rows do not start unusually low on each page.
Margins, orientation, and scaling still matter
Centering changes placement; it does not make a wide or long range fit on one page. If columns are cut off, use Page Layout > Orientation to consider Landscape, adjust margins with Page Layout > Margins, or review scaling under the Page Layout tab’s Scale to Fit controls. In the Page Setup dialog, the Page tab also provides scaling choices such as fitting the output to a specified number of pages.
Use scaling carefully. Setting a wide report to fit one page wide can keep all columns together, but it may shrink text until it is hard to read. Fitting both width and height to one page can reduce a long report dramatically. Center on page will not correct that small-text problem; it only positions the scaled result. Preview the printout at a readable size and, if necessary, allow the report to span more than one page.
Margins can also make a centered report appear off-center relative to the paper. If the left margin is much wider than the right, the content may be centered between those margins while not appearing centered on the physical sheet. In Custom Margins, compare the left and right values, and the top and bottom values if vertical placement is at issue. Headers and footers, printer limitations, and selected paper size can also affect how the page looks.
Check page breaks and multi-page reports
A print area may span more than one printed page, either because it contains many rows or columns or because the chosen paper size and scaling do not fit it on one page. Centering is a page-layout option, not a way to combine those pages into one. Review the page count and each page in Print Preview. If a column is stranded on a separate page, adjust orientation, scaling, margins, or the page breaks rather than expecting centering to pull it back.
For a long report, decide whether the goal is to center the content horizontally while keeping it near the top, or to center it vertically as well. The latter can make pages with different amounts of content look uneven. If column headings should repeat on each printed page, use Page Layout > Print Titles to set rows to repeat at the top; this is separate from Center on page. Repeating headings can improve readability but uses space on each page, so check the preview again afterward.
To inspect or adjust page breaks, choose View > Page Break Preview. This view helps show where Excel divides the worksheet for printing. Return to Normal view when finished. Changes to page breaks can change which rows or columns appear together, but they do not replace the centering controls in Page Setup.
Excel for Mac and Excel for the web
In Excel for Mac, open the Page Layout tab and use Margins > Custom Margins to find the page-centering choices in Page Setup. The dialog’s appearance can vary slightly by release, but the relevant options are on its Margins tab. To view printing options, use File > Print or press Command+P; the Windows shortcut is Ctrl+P.
Excel for the web has fewer page-setup controls than the desktop application, and the Center on page option may not be available there. If you cannot find it, open the workbook in the desktop Excel app and set the alignment in Page Setup. You can then use the desktop print preview to verify the layout. Menu availability can change as Microsoft updates the web app, so the desktop method is the dependable route when exact print positioning is required.
Common alignment problems and fixes
- The content is still off to one side: confirm that Horizontally is selected, then check whether unequal left and right margins or the printer’s printable area explain the appearance.
- The sheet looks centered on screen but not on paper: worksheet cell alignment and print centering are different settings. Use Page Setup’s Center on page options and inspect Print Preview.
- Only part of the report appears: check the defined print area. Clear it or select the correct cells and set it again.
- The report is centered but too small: review Scale to Fit or the fit-to-pages setting. Centering does not enlarge the content or improve its readability.
- A short report starts too low: uncheck Vertically if you want the content to begin closer to the top margin.
- Pages appear unexpectedly: inspect nonadjacent print areas, page breaks, paper size, and scaling in Print Preview.
One common misconception is that Center on page means center the selected cells in the worksheet window. It does not: it is a print setting. Another is that centering automatically fits a report to the page. Fitting controls scale; centering controls position. Treat them as separate decisions and use the preview after changing either one.
Frequently Asked Questions
How do I center an Excel print area horizontally?
Choose Page Layout > Margins > Custom Margins, select Horizontally under Center on page on the Margins tab, and click OK. Check the result in File > Print.
How do I center a print area vertically on the page?
Open Custom Margins from the Page Layout tab and select Vertically under Center on page. This changes the printed position, not the worksheet cells. Clear the option if the content begins too far down the page.
Can I center a print area both horizontally and vertically?
Yes. Select both checkboxes in the Center on page section of the Margins tab. This is most useful for a compact, one-page item; large or multi-page reports may be less readable when vertically centered.
Why is my Excel printout not centered even after I select the option?
Check that you selected the correct direction, that the intended cells are in the print area, and that the margins are suitable. Also verify the page in Print Preview, since scaling, paper size, page breaks, and printer limitations can affect the apparent position.
Does centering make the print area fit on one page?
No. Centering changes placement only. Use the Scale to Fit controls or Page Setup’s page-scaling options to change how many pages the range occupies, and confirm that the resulting text remains legible.
How do I remove a print area in Excel?
Choose Page Layout > Print Area > Clear Print Area. That clears the range restriction; it does not delete worksheet data or necessarily reset other page settings such as margins or centering.
Related
- Excel Group Rows Together for Sorting: What Actually Works
- Excel Group Rows: How to Keep the First Row Visible
- Excel Group Rows Count: How to Count Rows in Groups
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut for Filling a Cell YellowIn Excel for Microsoft 365 on Windows, press Alt, then H, then H to open the Fill Color…
- Excel Number Stored as Text: Causes and FixesExcel’s “Number stored as text” message is an error-checking warning, not a calculation error: a cell contains digits…
- Remove a Range Name in Excel: Step-by-Step GuideTo remove a range name in Excel for Microsoft 365 on Windows, open Formulas > Name Manager, select…
- How to Get Text to Wrap in Excel Without Changing ColumnsTo get text to wrap in Excel, select the cell or cells, then choose Home > Wrap Text.…
- Share Outlook Calendar URL: Links and AccessTo share an Outlook calendar URL, open Outlook on the web, go to Settings > Calendar > Shared…
- PowerPoint Will Not Animate Text? Causes and Fixes in SlidesPowerPoint can animate text, so if it will not, first select the text box and apply an effect…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.