To center a worksheet horizontally and vertically in Excel 2010, click the Page Layout tab and click the small arrow in the corner of the Page Setup group. On the Margins tab, check both Horizontally and Vertically under Center on page, then click OK. Your data now prints in the middle of the page. The steps are the same in Excel 2013, 2016, 2019, 2021, 2024, and Microsoft 365.
Centering only affects printing and PDFs, not how the sheet looks while you work. Here’s how to set it up, check it, and apply it to several sheets.
How to center a worksheet on the printed page
- Open the worksheet you want to print.
- Click the Page Layout tab.
- Click the small arrow (dialog box launcher) in the bottom-right corner of the Page Setup group.
- Click the Margins tab.
- Under Center on page, check Horizontally, Vertically, or both.
- Click OK.
Other ways to open Page Setup
- Go to File > Print and click Page Setup at the bottom of the settings.
- Or in File > Print, click the margins menu and choose Custom Margins.
Check the result in Print Preview
Press Ctrl + P or go to File > Print. The preview on the right shows exactly where your data will land on the page.
Center several worksheets at once
- Hold Ctrl and click each sheet tab you want to change. To select all sheets, right-click a tab and choose Select All Sheets.
- Open Page Setup and check the Center on page options.
- Click OK.
- Right-click a sheet tab and choose Ungroup Sheets so you don’t accidentally edit all of them.
Tips for a well-placed printout
- Set a print area to print only part of the sheet: select the cells, then Page Layout > Print Area > Set Print Area. Centering then applies to that area.
- Fit to one page: In Page Setup > Page, choose Fit to 1 page wide by 1 tall for small tables.
- Change orientation: Wide tables often look better in Landscape (Page Layout > Orientation).
- Adjust margins on the Margins tab if the data is close to the edge.
Frequently asked questions
Why doesn’t my worksheet look centered on screen?
Center on page only changes the printed page and PDFs. The normal view doesn’t change.
Does centering save with the file?
Yes. Page setup settings are saved with each worksheet.
How do I center text inside cells?
That’s different. Select the cells and use the Center and Middle Align buttons in the Alignment group on the Home tab.
Can I center a worksheet in Excel for Mac?
Yes. Go to File > Page Setup > Margins and check the Center on page options.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.