How to Center Worksheets Both Horizontally & Vertically in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Center worksheets on a page in the Page Setup menu.
Image Credit: Image courtesy of Microsoft.

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.

Advertisement

Centering Worksheets for Printing

Video of the Day

Step 1

Click the Page Setup "Dialog Box Launcher."
Image Credit: Image courtesy of Microsoft.

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."

Advertisement

Video of the Day

Step 2

The Page Setup dialog box.
Image Credit: Image courtesy of Microsoft.

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.

Advertisement

Step 3

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

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.

Advertisement

Advertisement

Centering Content Inside Cells

Step 1

A worksheet with highlighted cells.
Image Credit: Image courtesy of Microsoft.

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.

Advertisement

Step 2

Click the "Middle Align" icon.
Image Credit: Image courtesy of Microsoft.

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.

Advertisement

Advertisement

Step 3

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

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.

Advertisement

Advertisement

references