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.

Frequently Asked Questions About How to Center a Worksheet Horizontally or Vertically in Excel

How to center worksheet horizontally in Excel?

If you are only trying to center your spreadsheet horizontally on the page when you print, then you can do so by going to Page Layout > Page Setup > Margins and checking the box to the left of Horizontally.

How to center worksheet vertically in Excel?

Like the option discussed above, you can also elect to format your spreadsheet so that it is only centered on the vertical axis of the page. Simply select the Page Layout tab, click the Page Setup button, choose the Margins tab, then check the box to the left of Vertically under the Center on page section.

How do you center a worksheet both horizontally and vertically?

Luckily the options for horizontal and vertical centering in Excel are on the same menu, so switching between one or the other, or choosing both, doesn’t really require a lot of extra effort.

You can center both horizontally and vertically in Excel by going to Page Layout > Page Setup> Margins> then checking the boxes next to the Horizontally and Vertically options.

How do you center a table for printing in Excel?

While the distinction can be a little difficult to understand at first, a table in Excel is basically just a formatting option that you apply to existing cell data. If you want to center a table for printing in an Excel spreadsheet then you would use the same centering options that we have discussed in this article.

This means that centering a table for printing in Excel requires you to check the Horizontally or Vertically boxes found on the Margins tab of the Page Setup dialog box.

How do I change the orientation of all worksheets in Excel?

One of the neat things about working with worksheets in Excel is that you can apply the same changes to all of the different worksheets in a workbook.

If you want to change the orientation of every worksheet in an existing workbook, simply right click on one of the sheet tabs at the bottom of the window, then choose the Select All Sheets option. You can then click the Page Layout tab, click the Orientation button, then select the desired orientation. Because all of the worksheets were selected, this results in all of them having the same page orientation when you print them.

How do I make my Excel sheet fit on one page?

You can force your entire Excel spreadsheet to fit on one page by clicking the File tab at the top left of the page, selecting Print, then clicking the No Scaling button and choosing the Fit Sheet on One Page option.

Note that Excel does not care how big the cell data becomes when you choose this setting. It will print everything in unreadably small text if it’s a very large spreadsheet.

More Information on Centering When Printing in Excel

While adjusting the print settings for a document that you have created can be somewhat simple once you familiarize yourself with everything, it can be a nightmare when you are working with a spreadsheet that someone else created. If you have hit a roadblock and aren’t able to remove one of their formatting options, one of the best things you can do is simply copy all of the data in the cells, then paste it into a new spreadsheet. You can select all by clicking on the gray button above the row 1 heading, and to the left of the column A heading.

The Page Setup dialog box that you open when clicking that tiny button in the ribbon provides access to probably the most important menu when it comes to formatting a printed spreadsheet. Check out each of those tabs so that you can do things like center the worksheet horizontally or vertically, repeat rows at the top of each page, or even create custom margins for your printed sheet.

The Print Preview window that you see at the right side of the screen on the Print menu is a very useful tool that can prevent you from wasting a lot of ink and paper. After you make an adjustment to your document’s layout, open that Print menu and check the Print preview to ensure that it has created the desired result. You can open the Print menu more quickly with the Ctrl + P keyboard shortcut.

If your printed page is just slightly off, then there are some minor changes you can make before taking drastic measure. Try switching the worksheet from portrait or landscape orientation to the other option, or use the custom margins option to make the margins smaller. There is also a button on the Print menu that says “No Scaling” by default. If you click that button you will see options to fit the whole sheet on one page, or simply fit all of the rows or columns on one page. I use this a lot when I have a spreadsheet that is printing extra pages that only have a row column or two on them.

Additional Sources

Leave a Comment