To center a page horizontally in Excel, open Page Layout > Margins > Custom Margins, select Horizontally under Center on page, and check the result in Print Preview. This print setting centers the worksheet content between the page margins; it does not change how cells are aligned on screen. Before you start, decide which cells you want to print, since centering a defined print area is usually easier to control than centering an entire sheet.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows. The same page setup option is available in desktop Excel for Mac, although ribbon labels or dialog placement can vary slightly.
- A worksheet with content you intend to print. A printer is optional: Print Preview lets you check the layout without printing.
- An optional print area if you want to center only a specific block of cells. You can set one from the Page Layout tab.
Step-by-Step
- Open the worksheet you want to print. If the workbook has several sheets, click the relevant sheet tab first. Page setup options can apply to the active worksheet, so check that you have selected the right sheet before changing anything. If you want the same setup on several sheets, you can group the sheets first, but be careful: changes made while sheets are grouped can affect every selected sheet.
- Choose the content to include, if needed. To center a particular table or report rather than all used cells, select the cells you want on the worksheet. Go to Page Layout > Print Area > Set Print Area. Excel will use that range for printing. If a print area was already set and is not the range you need, choose Page Layout > Print Area > Clear Print Area, then select the correct cells and set the area again. This step is optional; if you do not set a print area, Excel determines the printed content from the sheet and its print settings.
- Open the custom margin settings. On the ribbon, select Page Layout > Margins > Custom Margins. Excel opens the Page Setup dialog on its Margins tab. The preset margin choices are useful for common layouts, but the centering controls are in Custom Margins. In desktop Excel for Mac, look for the same Margins and Custom Margins controls on the Page Layout ribbon; if the ribbon layout differs, open Page Setup from the File menu and locate its Margins tab.
- Turn on horizontal centering. In the Page Setup dialog, find the Center on page section. Select the checkbox labeled Horizontally. Leave Vertically unchecked unless you also want the content centered from top to bottom. Click OK to apply the setting. Horizontal centering and vertical centering are separate options, so selecting one does not automatically select the other.
- Inspect the print preview. Choose File > Print or press Ctrl+P on Windows. In the preview, check that the printed content sits between the left and right margins and that no columns or rows have been left out. On a Mac, use Command+P to open the print screen. You can use the preview controls to move between pages if the worksheet spans more than one page.
- Adjust the layout if the preview is not right. Return to Page Layout > Margins > Custom Margins to change the margins or confirm that Horizontally remains selected. If the content is too wide, consider changing orientation to Landscape or using a suitable scaling option under Page Layout > Scale to Fit. Reopen Print Preview after each change. Scaling changes the size of printed content; centering changes its placement, so one setting does not replace the other.
- Print when the preview looks correct. Select the printer and any required options in the print screen, then print. If you are saving a PDF instead, use the available PDF option in the print screen and check the resulting pages. The centering setting is part of the worksheet’s page setup, so save the workbook if you want to keep the layout for later.
Common Mistakes
Confusing print centering with cell alignment. The alignment buttons on the Home tab move text inside its cell. They do not position the whole printed worksheet on the paper. Use the Page Setup Margins tab for page centering.
Centering the wrong range. If Excel includes extra blank-looking columns or rows, the print area may be larger than the visible report. Set a precise print area before centering, and check the preview to see exactly what Excel will print.
Expecting the worksheet to move on screen. The checkbox affects printed pages and print preview, not the normal worksheet grid. It will not reposition cells or change the view while you edit.
Using vertical centering by mistake. Selecting only Vertically moves the content between the top and bottom margins but does not center it from left to right. Check the label before closing the dialog.
Assuming centering fixes every layout issue. A wide report can still be split across pages, and a narrow table may still appear small if scaling is set to fit a large range. Set the print area, orientation, and scaling deliberately, then preview the result.
Tips
- Set the print area first. This makes the target of the centering setting clear and prevents unrelated cells from influencing the printed layout.
- Use Print Preview as your final check. The page view shows how the print settings work together. Look at every page, not just the first one, if the sheet spans multiple pages.
- Keep left and right margins consistent if you want the content to look centered relative to the physical page. Unequal margins can make a correctly centered print area look offset on the paper.
- Consider page orientation before shrinking content. Landscape orientation can give a wide table more room. If you use scaling to fit a wide report onto one page, check that the text remains readable.
- Save a copy or save the workbook after adjusting page setup. This preserves your layout choices for the next time you print, while keeping the original file available if you need to compare settings.
Troubleshooting
The page still looks off-center. First confirm that you are judging the print preview, not the worksheet grid. Then return to the Margins tab and check that Horizontally is selected. Review the left and right margin values as well. If they differ, adjust them to match and preview again. Also check whether the printed range itself contains empty columns or uneven spacing that makes the visible table appear off-center even when the range is centered.
Only part of the sheet appears in preview. Check for an old or overly narrow print area under Page Layout > Print Area. Clear it and set the intended range again. Also look at the page breaks and the number of pages in the preview. Horizontal centering does not make a wide range fit on one page; change orientation or scaling separately if that is the goal.
The option is missing or unavailable. Make sure you opened Custom Margins rather than choosing one of the preset margins. In Excel for the web, print and page setup controls can be more limited than in the desktop application. If you cannot find the centering checkbox there, open the workbook in desktop Excel and use the Page Setup dialog. On a Mac, check the Page Setup dialog’s Margins tab if the ribbon command is arranged differently.
The preview does not match the paper output. Confirm that the selected printer and paper size match the paper loaded in the printer. A different paper size, printer driver, or printer-specific printable area can change the apparent margins. Choose the intended paper size in the Page Setup options, then review the preview again. For a PDF, check that you are viewing the file at a useful zoom level before judging alignment.
The setting seems to affect another sheet. Check whether multiple worksheet tabs are grouped. When sheets are grouped, page setup changes can be applied to all selected sheets. Right-click a selected sheet tab and choose Ungroup Sheets, or click a single sheet tab, then configure the page you intend to print.
Frequently Asked Questions
Does horizontal centering change the worksheet itself?
No. It changes the printed page layout and its appearance in Print Preview. The cells stay in their original positions on the worksheet, and their text alignment is unchanged.
Can I center a selected table instead of the whole worksheet?
Yes. Select the table’s cells and choose Page Layout > Print Area > Set Print Area before enabling horizontal centering. Preview the result to confirm the selected range is the only content included.
Will this center every page if my worksheet prints on multiple pages?
The horizontal centering option applies to the printed page layout, including pages produced from a multi-page worksheet. Check each page in Print Preview because page breaks and the content on individual pages can make them look different.
Does this setting center the content vertically too?
No. Select Horizontally for left-to-right centering. Select Vertically separately if you also want the content positioned between the top and bottom margins.
Can I center a worksheet on screen with this setting?
No. This setting is for printing. To change how cell contents look in the worksheet, select cells and use the alignment controls on the Home tab; that affects cell content, not the position of the printed page.
Can I center a page in Excel for the web?
Excel for the web has more limited page setup options than desktop Excel, and the horizontal centering checkbox may not be available. If you cannot find it in the web app, open the workbook in desktop Excel and set it in the Page Setup Margins tab.
Related
- Append Data in Excel with Power Query: A Step-by-Step Guide
- How to Align Text in Excel Without Merging Cells
- Align a Page in Excel for Printing: Center and Position
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Keep Date Format in ExcelTo keep dates consistent in Excel, select the cells or column, open Format Cells, choose a date format,…
- Excel Format by Number Range with Conditional FormattingTo format Excel cells by number range, select the cells and choose Home > Conditional Formatting > Highlight…
- Excel Data Validation: Add Criteria and RulesTo add criteria in Excel Data Validation, select the cells, go to Data > Data Validation > Data…
- Track Changes in Word: How to Review and Accept EditsTo use Track Changes in Microsoft Word, open the Review tab and select Track Changes; Word will mark…
- How to Average Dates in ExcelTo average dates in Excel, use =AVERAGE(A2:A10) when the cells A2:A10 contain valid Excel dates. Format the result…
- How to Archive Multiple Emails in OutlookTo archive several emails in Outlook, select the messages in your inbox or another mail folder, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.