How to center a worksheet in Excel

  • Post author:
  • Post category:Uncategorized

Normally, we input data in a worksheet starting with the A1 cell.  Upon printing, we find that Excel prints our data exactly as it is positioned in the spreadsheet.  Below example shows how a worksheet is printed, by default.

Figure 1.  Print preview of worksheet

Note that the table is printed with the first cell at the top left corner of the page.  

How to center a worksheet

When we want to print a worksheet in Excel such that it is printed in the center of the page, we need to adjust some page settings in Margins under Page Setup.  We can access Margins through any of the following methods:

  • Page Layout tab > Margins Custom Margins

Figure 2.  Custom Margins option in Page Layout

Clicking Custom Margins will launch the Page Setup > Margins dialog box.  

Figure 3.  Margins dialog box in Page Setup

  • File Print Page Setup > Margins

Figure 4.  Print settings in Excel through File > Print

Clicking the Page Setup link at the lower portion of the menu will launch the Page Setup dialog box.  

Figure 5.  Page Setup dialog box

When we click the Margins tab, we are presented with the dialog box for margin settings, which includes the checkboxes for centering of page horizontally and vertically.  

Figure 6.  Margins dialog box showing center on page options

  • Ctrl P > Page Setup > Margins

This method is similar to the previous method, but using the keyboard shortcut Ctrl + P instead of File Print in menu options

  • Print Preview and Print button > Page Setup Margins

This method is also similar to the previous method, but using the shortcut button for Print Preview and Print at the top of the worksheet  

Figure 7.  Print Preview and Print shortcut button

We can employ any of the methods and still end up with the same Page Setup dialog box, Margins tab.  In the Margins dialog box, Excel allows us to perform the commands to center the selected worksheet horizontally, vertically, or both.  The checkboxes are located at the lower left corner of the pane.  

Figure 8.  Center on page checkbox options: Horizontally and Vertically

How to center a worksheet horizontally

In order to center a worksheet horizontally on the page, we follow these steps.  

  • Prepare our spreadsheet data

Figure 9.  Sample data to center worksheet

  • Launch the Margins dialog box through any of the methods discussed above.  In this case, let us use the Print Preview and Print button located at the top of the worksheet.  

Figure 10.  Print Preview and Print shortcut button

This will launch the Print settings and show a preview of how the worksheet will be printed.  

Figure 11.  Print settings showing print preview of worksheet

  • Click Page Setup at the lower portion of the menu.  This will launch the Page Setup dialog box.  

Figure 12.  Page Setup dialog box via Print settings

  • Click the Margins tab and check the checkbox under Center on page: Horizontally

Figure 13.  Check checkbox for Horizontally in Margins dialog box

  • Click OK

The worksheet will be centered horizontally on the page as shown below:

Figure 14.  Output: Center a worksheet horizontally

There are times, however, when we want the worksheet to be centered both horizontally and vertically.  

How to center worksheet horizontally and vertically

In order to center a worksheet horizontally and vertically in Excel, we have to check the two checkboxes for Horizontally and Vertically in the Margins dialog box.

Figure 15.  Check checkbox for Horizontally and Vertically in Margins dialog box

As a result, our worksheet will be located in the center of the page as shown below:

Figure 16.  Output:  Center a worksheet horizontally and vertically