How to Center Worksheet Horizontally and Vertically in Excel 2010

Printing in Microsoft Excel can be a frustrating endeavor. The default settings are often not ideal, which can leave you wondering how to do things like how to center a worksheet horizontally or vertically on the page in Excel 2010.

By default, Microsoft Excel 2010 will print your spreadsheet based upon how you have configured your data in the worksheet cells.

Since many Excel users start creating their spreadsheets from the A1 cell, this means that most Excel 2010 documents print from the top-left corner of the page.

You can change this, however, by adjusting a few page settings for your document. For example, if you want to center a worksheet horizontally and vertically in Excel 2010 when the document is printed, it is possible to configure your sheet so that your desired print layout occurs.

How to Center a Worksheet Horizontally and Vertically on the Page in Excel 2010

  1. Click the Page Layout tab.
  2. Select the Margins button.
  3. Choose the Custom Margins option.
  4. Click the box to the left or Horizontally and/or Vertically.

Our article continues below with additional information on centering a worksheet horizontally and vertically in Excel, including pictures of these steps.

How to Print an Excel 2010 Spreadsheet in the Middle of the Page (Guide with Pictures)

If you have attempted to achieve this effect on your own, then you likely investigated many of the options on the Print menu in Excel 2010. While you can achieve most of your required print settings from that menu, such as printing a two page spreadsheet on one page, this particular option is found on a different menu.

Step 1: Begin by opening the Excel spreadsheet in Excel 2010.

Step 2: Click the Page Layout tab at the top of the window.

center form the page layout tab

Step 3: Click the Margins drop-down menu in the Page Setup section of the ribbon at the top of the window, then click Custom Margins at the bottom of the drop-down menu.

custom margins from the margins drop-down menu

Step 4: Check the boxes at the bottom-left corner of the window under Center on page, to the left of Horizontally and Vertically.

how to center worksheet horizontally and vertically in excel 2010

Step 5: Click the OK button.

You can then see what your printed Excel spreadsheet will look like on the page by clicking the File tab at the top-left corner of the window, then clicking the Print option. For example, a small sample set of data that I created looks like this when centered –

centered sample worksheet

You can also access the Print menu by pressing Ctrl + P on your keyboard at any time. You can also make slight adjustments to your margins if you need to tweak the layout of your centered information.

Alternate Method for Centering a Worksheet in Excel

The steps above enable you to center your printed spreadsheet horizontally and vertically through the Margins menu, but you can also access this menu in another way.

Step 1: Click the Page Layout tab.

click page layout tab

Step 2: Click the small Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.

open page setup menu

Step 3: Choose the Margins tab at the top of the window.

click the margins tab

Step 4: Check the box to the left of Horizontally or Vertically, based on your centering needs.

how to center horizontally and vertically in excel

The methods described above are just one of the many ways that you can improve the way your spreadsheet prints. This guide walks you through some more of the options that can make printing in Excel a little easier.

See also newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.