To align a worksheet 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 Print Preview before printing. These options position the printed worksheet on the paper; they do not change how text is aligned inside cells.
Before you begin, decide which sheet and page you want to print. If you mean cell contents rather than the printed page, use the alignment controls on the Home tab instead.
What You’ll Need
- An Excel workbook with the worksheet you want to print.
- A printer, or access to Print Preview, to check the page layout.
- The intended paper size and orientation, if you know them. If not, you can confirm them in Excel before printing.
Step-by-Step
-
Choose the worksheet to print. Click its sheet tab. If you want only part of the sheet, select the cells first, then choose Page Layout > Print Area > Set Print Area. Excel will use that selection as the printed area. To remove an existing print area, choose Page Layout > Print Area > Clear Print Area. This is useful when an old setting is causing Excel to print unexpected cells or extra pages.
-
Set the paper orientation and size. On the Page Layout tab, choose Orientation and select Portrait or Landscape. Choose Size to select the paper size, such as Letter or A4. Match these choices to the paper loaded in the printer. A wide table often fits more naturally in landscape, while a narrow report may suit portrait.
-
Open the page margins settings. Choose Page Layout > Margins > Custom Margins. You can also open the Page Setup dialog by clicking the small dialog box launcher at the lower-right corner of the Page Setup group on the Page Layout tab, then selecting its Margins tab. Either route takes you to the settings that control page placement.
-
Center the worksheet horizontally, vertically, or both. In the Margins tab, find Center on page. Select Horizontally to balance the printed area between the left and right margins. Select Vertically to balance it between the top and bottom margins. Select both boxes to center the printed area in the middle of the page. Click OK to apply the settings.
For example, a small table that looks crowded at the top-left of a sheet may look more polished when centered both ways. A long list that should start near the top can be centered horizontally only, so Excel does not shift it toward the middle vertically.
-
Review the margin measurements. In the same dialog, check the top, bottom, left, and right margins. Centering works within the printable area between these margins; it does not override them. If a header or footer is close to the edge, check its header or footer margin too. Avoid setting margins so small that the printer cannot reproduce them, since many printers have a non-printable edge.
-
Adjust scaling only if the content does not fit. Centering changes the placement of the content, not its size. If columns spill onto another page, use the Scale to Fit controls on the Page Layout tab, or open the Page Setup dialog and use the Page tab. For a wide worksheet, setting the width to one page and leaving the height automatic can keep columns together while allowing rows to continue on additional pages. Check that the text remains readable; forcing a large sheet onto one page can make it too small.
-
Check the page breaks and print area. Choose View > Page Break Preview to see where Excel divides the sheet into printed pages. If you see an unexpected page, return to the worksheet and check for stray data, a large print area, or a manual page break. You can adjust breaks in this view, but confirm the layout again after making changes because scaling and paper settings affect page breaks.
-
Preview and print. Press Ctrl+P on Windows to open the Print screen, or choose File > Print. Check the preview for the page position, clipping, blank pages, and page count. Use the navigation controls to inspect every page, not just the first. Confirm the selected printer, paper size, and orientation, then print when the preview matches what you need. On a Mac, use Command+P to open the print dialog; the precise preview and printer controls can differ by macOS and printer.
Common Mistakes
-
Confusing page alignment with cell alignment. The center options in Custom Margins position the printed worksheet on paper. To center text inside a selected cell, use Home > Alignment and choose a horizontal or vertical cell alignment option.
-
Expecting centering to fix an oversized worksheet. A sheet that is too wide can still print across multiple pages when centered. Set a suitable print area or adjust scaling first, then review the preview.
-
Centering vertically when the report should begin at the top. Vertical centering can leave a short report halfway down the page. If that is not the intended look, clear the Vertically checkbox and keep horizontal centering if needed.
-
Ignoring printer settings. Excel may show one paper size while the printer dialog uses another. A mismatch can change margins, wrapping, and page breaks. Set the paper size consistently in Excel and in the printer properties.
-
Checking only the worksheet grid. The screen view does not show precisely where printed content will land. Use Print Preview because headers, footers, scaling, margins, and printer limits can affect the result.
Tips
-
Save a separate copy before making significant print-layout changes if the workbook contains carefully configured print areas, breaks, or page settings.
-
For a compact table, try centering both horizontally and vertically. For a multi-page report, horizontal centering may be enough; vertical centering is most useful when each printed page should have its content balanced from top to bottom.
-
Use the Margins menu’s preset options as a starting point, then choose Custom Margins to refine the settings. A preset can quickly establish a reasonable layout, but it will not necessarily center the content.
-
If the worksheet has column headings that need to appear on every printed page, set them separately through Page Layout > Print Titles. Centering a page does not repeat headings on later pages.
-
When you print several sheets together, select the relevant sheet tabs first and inspect the print settings for each. Worksheets can have different print areas and layouts, so one sheet’s successful preview does not guarantee that the others are aligned the same way.
Troubleshooting
The page is still off-center. Reopen Page Layout > Margins > Custom Margins and verify the appropriate Center on page box is checked. Then check for unequal margins, a header or footer, or content extending beyond the intended table. The printed area includes whatever Excel considers part of the print area, so a stray value far to the right or below the table can make the visible data appear shifted. Clear and reset the print area if necessary.
Only some pages are centered, or pages look different. Check whether the worksheet prints on multiple pages and whether page breaks divide the data unevenly. Preview each page. Centering is applied to the printed content on its page, but pages with very different amounts of content can still look visually unbalanced. Consider setting a print area, adjusting scaling, or changing the page breaks. If you are printing multiple worksheets, review each sheet’s settings separately.
The content is cut off or has moved after printing. Confirm that the printer selected in Excel supports the paper size you chose. Open the printer’s properties from the Print screen if available, and make the paper size and orientation match Excel. If the preview itself is clipped, revisit margins, scaling, and the print area. If preview looks correct but the physical page differs, check the printer’s own scaling option; settings such as fit to printable area can alter placement after Excel sends the job.
The Custom Margins option or preview is unavailable. Make sure you are in a worksheet rather than another workbook view, and check that the workbook is not in a mode that restricts editing. On Excel for the web, print settings and dialog details can differ from the Windows desktop app; use its print command and review the browser or system print preview. If page-centering controls are not available there, open the workbook in Excel for Microsoft 365 on Windows and set the margins in the Page Setup dialog.
Frequently Asked Questions
How do I center a page horizontally in Excel?
Choose Page Layout > Margins > Custom Margins, select Horizontally under Center on page, and click OK. Preview the result before printing.
How do I center a worksheet vertically on a printed page?
Open Custom Margins and select Vertically under Center on page. This positions the printed area between the top and bottom margins; it does not center each cell’s contents.
Can I center a worksheet both ways?
Yes. Select both Horizontally and Vertically in the Custom Margins dialog. This is often suitable for a small table or a short form printed on one page.
Why is my Excel sheet not centered even though I selected the option?
Check that the correct sheet and print area are selected, and inspect the margins, scaling, and printer paper settings. A stray cell included in the print area can shift the apparent center. Use Print Preview to diagnose the layout.
Does page centering change the alignment of text in cells?
No. It affects the position of the printed worksheet on the paper. To align text within cells, select the cells and use the alignment controls on the Home tab.
Can I center the page in Excel for Mac?
Yes. Excel for Mac also provides page setup and margin controls, although the dialog layout and print workflow can vary by version. Open the page setup or margins options, choose horizontal or vertical centering, and inspect the macOS print preview.
Related
- Excel Zoom Shortcut: Fast Ways to Change Magnification
- Excel Yellow Color Code: RGB, Hex, and Theme Values
- ISBLANK in Excel: How It Works and When to Use It
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 to Delete Cells and Shift Them UpwardIn Excel for Microsoft 365 on Windows, select the cells to remove, press Ctrl+- (Ctrl and the minus…
- How to Insert a Green Checkbox in ExcelTo add a clickable checkbox in Microsoft Excel for Microsoft 365 on Windows, select the target cell or…
- How to Use Styles in Word for Clear, Consistent DocumentsTo use styles in Word, select the text or place your cursor in a paragraph, then choose a…
- Create Outlook Rules to Delete Spam Messages AutomaticallyTo create an Outlook rule that deletes recurring spam, open Settings > Mail > Rules in new Outlook…
- Meal Planner Excel Spreadsheet: Plan a Week of MealsYes. A meal planner Excel spreadsheet can organize a week’s meals, servings, prep time, and grocery needs in…
- How to Add Page Numbers in Word Documents, Step by StepTo add page numbers in Word for Microsoft 365 on Windows, open the document and select Insert >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.