How to Center Worksheets Both Horizontally & Vertically in Excel

Before printing a worksheet in Excel 2013, you can specify how you want it aligned on the page, including centering it vertically and horizontally, using the Page Setup options. If you want to center the numbers or text inside each cell, you can do that using the options under the Home menu.

...
Center worksheets on a page in the Page Setup menu.
credit: Image courtesy of Microsoft.

Centering Worksheets for Printing

Step

Open the worksheet you want to print. To print multiple worksheets from the same workbook, hold down the "Shift" key and click the worksheet tabs at the bottom of the window. Click the "Page Layout" menu, then click the Page Setup "Dialog Box Launcher."

...
Click the Page Setup "Dialog Box Launcher."
credit: Image courtesy of Microsoft.
...
The Page Setup dialog box.
credit: Image courtesy of Microsoft.

Step

Select your printer preferences in the Page Setup dialog box, including the page orientation, paper size and print quality. To fit a large worksheet onto a single page, use the "Fit To" option in the Scaling section.

...
Select the Center on Page options under the Margins tab.
credit: Image courtesy of Microsoft.

Step

Click the "Margins" tab in the Page Setup dialog box. Specify the margins you want and then click the "Horizontally" and "Vertically" checkboxes in the Center on Page section. When both of these checkboxes are marked, the worksheet is centered directly in the middle of the page.

Centering Content Inside Cells

Step

Select the cells you want centered by dragging the cursor across them. To select an entire worksheet, click the "Select All" button in the upper-left corner.

...
A worksheet with highlighted cells.
credit: Image courtesy of Microsoft.
...
Click the "Middle Align" icon.
credit: Image courtesy of Microsoft.

Step

Click the "Home" menu, then click the "Middle Align" icon in the Alignment group. This centers the content of each cell so that there's an equal amount of space on the left and right.

...
Click the "Center" icon.
credit: Image courtesy of Microsoft.

Step

Click the "Center" icon located directly below the Middle Align icon. This centers the content of each cell so that the space above and below the content is the same.