To center a table on a printed page in Excel, open Page Layout, launch the Page Setup dialog, choose the Margins tab, and select Center on page: Horizontally, Vertically, or both. This changes the table’s position on the printout, not the alignment of text inside worksheet cells. Before you start, make sure the range you want to print is clear and that the paper size and orientation are appropriate.
What You’ll Need
- Excel for Microsoft 365 on Windows, with the workbook open.
- A table or cell range ready to print. If the worksheet contains other material, decide which range should appear on the page.
- A printer is optional. You can use Print Preview to check the result without printing.
Step-by-Step
- Identify the range you want on the page. If the worksheet contains only the table and nothing else you need to print, you can leave the print area unset. If it contains notes, other tables, or empty columns that should not appear, select the cells that belong in the printout. Include column headings or a title if you want them printed. You do not need to select cells just to center the whole worksheet’s printout.
- Set a print area if you want to print only part of the worksheet. With the intended cells selected, go to Page Layout > Print Area > Set Print Area. Excel will use that range as the printable content. If a previous print area is interfering, choose Page Layout > Print Area > Clear Print Area, then select the correct range and set it again. Setting the print area is optional when the whole used worksheet is what you intend to print.
- Open the page setup controls. Select the Page Layout tab. In the Page Setup group, click the small dialog box launcher at the group’s lower-right corner. In the dialog that opens, select the Margins tab. Depending on your Excel window size, the group may be compact, but the dialog launcher remains the small arrow icon. You can also reach page setup through the print screen’s page setup link in some Excel builds; the Page Layout dialog launcher is the most direct route.
- Choose the direction of centering. In the Center on page area of the Margins tab, select Horizontally to center the output between the left and right margins. Select Vertically to center it between the top and bottom margins. Select both boxes to place a small table near the middle of the printable area in both directions. Leave either box clear if you want to control that direction yourself with margins or page breaks.
- Confirm the settings. Click OK to apply them to the worksheet’s print setup. Centering does not resize the table or change cell contents. It positions the printable output within the available page area. The area available for printing is affected by the margins and by printer limits, so the center of the printable area may not be exactly the center of the physical sheet.
- Check the print preview. Press Ctrl+P on Windows to open the print screen. Review the preview and use the page arrows if Excel shows more than one page. Confirm that the table is centered as intended, all required columns and rows are present, and the print area does not include unwanted cells. If you need to adjust the paper, orientation, or scaling, return to the worksheet’s Page Layout options or use the available print settings, then check the preview again.
- Print only after checking the layout. Choose the correct printer and page settings, then print. If you only need a PDF, select an available PDF printer or use Excel’s PDF export options. The same page setup alignment is used for a PDF output, so preview it before saving or sharing.
Mac and web notes: Excel for Mac has a similar Page Layout and Page Setup workflow, though the dialog’s appearance can differ; look for the Margins tab and the Center on page checkboxes. Keyboard shortcuts also differ: use Command+P to open Print on Mac rather than Ctrl+P. Excel for the web has more limited page setup controls and may not expose the Center on page options. If you cannot find those checkboxes in the browser, open the workbook in the desktop Excel app and set them there.
Common Mistakes
Confusing page centering with cell alignment. The Center button on the Home tab centers text within selected cells. It does not center the table on the printed sheet. For page positioning, use the Center on page options in Page Setup.
Centering the wrong print range. A leftover print area can cause Excel to center an unexpected set of cells, including blank columns or a second table. Clear the old print area and set the intended range again when the preview does not match your selection.
Expecting centering to fix a table that is too wide. Centering shifts the output; it does not make columns narrower or reduce the number of pages. If columns are cut off or split across pages, adjust orientation, margins, column widths, or scaling separately.
Using uneven margins without checking the result. Excel centers within the printable area defined by the margins, not necessarily the physical page edges. If the left and right margins differ, the output may look off-center on the paper even though it is centered between those margins.
Changing worksheet formatting instead. Merging cells, adding spaces, or inserting blank columns to push a table toward the middle can disrupt sorting, formulas, and later edits. Use the print setup option for a print-only adjustment.
Tips
- Choose the print area first. Centering is easiest to judge when Excel is printing only the content you want. Include the header row, title, or notes that should accompany the table.
- Try horizontal centering first. A table that spans several rows often looks best centered left to right but positioned toward the top of the page. Use vertical centering only when the design calls for it, such as a compact report intended to sit in the middle of one sheet.
- Use orientation and scaling deliberately. If a wide table needs to fit, landscape orientation may help. In the Page Layout tab’s Scale to Fit settings, you can adjust width or scale, but forcing a large table onto one page may make the text too small to read. Check the preview at its actual page size.
- Set margins before judging alignment. Narrow or custom margins change the printable area and therefore the point around which Excel centers the output. Use consistent left and right margins when visual symmetry matters.
- Save a print-ready copy or preserve the original layout settings. Page setup choices are saved with the worksheet. If you need different layouts for different purposes, consider duplicating the sheet before changing its print area, margins, or scaling.
Troubleshooting
The table still appears left-aligned. Reopen Page Layout > Page Setup dialog launcher > Margins and confirm that Horizontally is checked. Then verify that the print preview is showing the correct sheet and print area. If the table nearly fills the printable width, the small remaining margins can make the centering difficult to notice.
The preview shows a blank page or extra pages. Go to Page Layout > Print Area > Clear Print Area, select the intended table cells, and set the print area again. Also look for stray content far to the right or below the table, as Excel may include it in the print range if the print area is not set. Check the page arrows in Print Preview to see whether the output spans multiple pages.
The table is centered but too small or too large. Centering does not control scale. Review the Scale to Fit settings on Page Layout and the scaling choices in the Print screen. If Excel is shrinking the output to fit, try landscape orientation or narrower columns before reducing the scale further. If the printout is unexpectedly enlarged, change the scaling option back to a normal or manually selected scale.
The table is centered between margins but not on the physical sheet. Reopen the Margins tab and compare the left and right margin values, and the top and bottom values if you used vertical centering. Adjust them to be equal if you want the printable area to be symmetrical. Some printers also have nonprintable edge areas; the printed result can differ slightly from the preview because of the printer’s hardware limits.
The centering controls are missing. Make sure you are in desktop Excel’s Page Setup dialog on the Margins tab, rather than the Home tab or a cell-formatting dialog. In Excel for the web, open the file in the desktop app if those controls are unavailable. On Mac, the dialog layout can differ, so look for the page setup margins rather than expecting the Windows dialog to look identical.
Frequently Asked Questions
Does centering a table on the page change the worksheet itself?
It changes the worksheet’s print layout, not the table’s cell positions or the alignment of text inside cells. The data stays in the same rows and columns.
Can I center a table horizontally but keep it at the top?
Yes. In the Margins tab, check Horizontally and leave Vertically unchecked. Excel will center the output between the side margins without vertically centering it on the page.
Can I center a table on every page if it prints across multiple pages?
The Center on page settings apply to the worksheet’s printed pages, but centering alone will not make a multi-page table behave like one single block. Use Print Preview to inspect each page and adjust page breaks, print area, or scaling if the split is awkward.
Why does the table look off-center even when the option is selected?
Excel centers within the printable area, which is set by the margins and can be affected by a printer’s unprintable edges. Unequal margins, extra blank columns, or a print area larger than the visible table can also make the result look uneven.
Can I center the table without printing it?
Yes. Use Print Preview to review the layout, or save/export the sheet as a PDF and inspect that file. You do not need to send the job to a physical printer to apply or check the page setup.
Does this work with an Excel Table object?
Yes. Excel’s print setup works with a formatted Table object as well as an ordinary cell range. If you want only the Table object included, select its cells and set that selection as the print area before previewing.
Related
- How to Align an Image in an Excel Cell and Keep It in Place
- How to Align Cell Size in Excel for a Neater Sheet
- Excel Cell Alignment Shortcuts: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Workbook Not Showing Sheet Tabs? Fixes That WorkIf an Excel workbook is not showing sheet tabs, first check File > Options > Advanced and, under…
- How to Create a Signature Line in Microsoft OutlookTo create an email signature line in Outlook, open the signature settings for your version of Outlook, write…
- Excel Column Categories: Data Types and LabelsExcel does not assign a universal set of “column categories.” A column is a vertical set of cells;…
- Excel Merge Cells Without Merging: Better AlternativesTo make cells look merged without actually merging them in Excel, select the range, open Format Cells with…
- Outlook Distribution List: How to Create OneTo create a personal distribution list in Outlook, open People, choose the option to create a contact group…
- How to Lock Cells in Google Sheets and Protect RangesTo lock cells in Google Sheets, select the cells, choose Data > Protect sheets and ranges, then set…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.