Have you ever printed a spreadsheet in Excel and it was aligned at the left side of the sheet? In some cases this is perfectly fine, but in other situations this could look bad or unprofessional.
Fortunately Excel 2010 has a number of different ways that you can customize the appearance of your printed spreadsheets, including a setting where you can center your worksheet horizontally and vertically. Our tutorial below will show you two ways to get to the menu where you are able to perform this centering.
Quick Summary – How to Center Horizontally and Vertically in Excel 2010 When Printing
- Click the Page Layout tab.
- Click the Page Setup button at the bottom-right of the Page Setup section in the ribbon.
- Select the Margins tab.
- Check the box to the left of Horizontally or Vertically, or both.
You can continue below for images of each step, as well as an alternate way to get to this menu.
How to Print a Centered Worksheet in Excel 2010
The steps in this article were performed in Microsoft Excel 2010, but will work in other newer versions of Excel as well. Note that you have the option to center horizontally, vertically, or both.
Step 1: Open the spreadsheet that you wish to center in Excel 2010.
Step 2: Select the Page Layout tab at the top of the window.
Step 3: Click the small Page Setup button at the bottom-right corner of the Page Setup section in the ribbon.
Step 4: Choose the Margins tab at the top of this window.
Step 5: Click the box to the left of Horizontally, Vertically, or both based on how you wish to center.
If you then press Ctrl + P on your keyboard or click the Print Preview button on this menu you will open the Print menu, where you will see a preview of the centered worksheet.
Alternate Method for Centering Horizontally and Vertically in Excel 2010
This method is very similar to the first method, we just go through the Margins option in the ribbon rather than through the Page Setup menu.
Step 1: Click the Page Layout tab at the top of the window.
Step 2: Click the Margins button, then choose the Custom Margins option at the bottom of the menu.
Step 3: Click the box to the left of the type of centering you wish to use.
Note that completing the steps above will not affect the appearance of your spreadsheet when you are editing in Excel. This setting only affects the way that the spreadsheet prints.
For more information on ways that you can make your printed spreadsheets look better, check out our Excel printing optimization guide and view some additional tips/