A lot of spreadsheets that you work with in Excel 2013 will be monstrous collections of data that span multiple sheets. Your concerns when printing these types of spreadsheets are typically focused on getting everything to fit on the least possible amount of pages. But occasionally you will have a spreadsheet that has a small number of columns, which can look bad when you print it, because it is left-justified.
Fortunately Excel allows you to change the centering for spreadsheets that you print, and it is possible to tell the program to center your cells on the sheet. The steps below will show you where tyo find the setting that you need to change.
Centering a Spreadsheet on the Page in Excel 2013
The steps below are going to center your cells when you print your Excel 2013 spreadsheet. While we are specifically focusing on centering the spreadsheet horizontally, there is a “Vertically” option on the last menu in this guide that you can use if you would also, or alternatively, prefer to center your spreadsheet vertically on the page.
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Click the Page Layout tab at the top of the window.
Step 3: Click the Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.
Step 4: Click the Margins tab at the top of the Page Setup window.
Step 5: Check the box to the left of Horizontally under Center on page. You can then click the OK button at the bottom of the window to apply your changes.
There are a number of settings that I prefer to adjust when I am printing a spreadsheet, and horizontally centering my spreadsheet is one of them. Another setting that I like to apply is printing the top row on every page. This makes it easier for my readers to understand the data that they are looking at on the second page and beyond of my spreadsheets, and it can help to prevent some potential confusion.