How to Center a Printed Spreadsheet in Excel 2013


Printing in Excel has always required a bit of configuration to get right, and you will likely find that there is something about your spreadsheet that you need to modify whenever you print it out. We have previously discussed how to print the top row on every page, for example, which is helpful to your readers because it helps them associate cells with the appropriate column.

But a spreadsheet that you print in Excel 2013 will anchor itself to the top-left of the page by default, while you might prefer to have that spreadsheet centered on your page. Fortunately you can achieve this result by making just a few simple changes to the settings for your spreadsheet.

 

Center Your Spreadsheet on the Page in Excel 2013

This article will show you how to configure your spreadsheet in Excel 2013 so that it prints on the center of the page. These steps will center the spreadsheet both vertically and horizontally. If you only wish to center it in one of these ways, then only select that option in Step 5 below below.

 

Step 1: Open your spreadsheet in Excel 2013.

 

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

click the page layout tab

 

 

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

click the page setup button

 

 

Step 4: Click the Margins tab at the top of the window.

click the margin tab

 

 

Step 5: Check the boxes to the left of Horizontally and Vertically under the Center on page section of the window. As mentioned earlier, you can choose to click only one of these options if you do not wish to apply a centering method to your spreadsheet. Click the OK button to save your changes.

check the center on page options

 

 

Are there columns of your spreadsheet that are being printed on separate pages and causing you to waste a lot of paper? Use the fit all columns on one page setting to minimize the amount of paper that you use to print your spreadsheets.

solveyourtech.com newsletter
vintage t rex t-shirt

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