An Excel 2013 spreadsheet that uses the default print settings will often be difficult for readers. It might also be off-centered, depending upon the number of columns that appear on this page. This can be unappealing, leaving you to look for solutions that will allow you to stop printing left-aligned data.
The setting for the printed page alignment in Excel is found on the Page Setup menu, under the Margins tab. Our tutorial below will direct you to that location so that you can elect to center the page either horizontally, vertically, or both.
How to Center Printed Pages in Excel 2013
The steps in this article will show you how to find the settings which control the alignment of your entire printed spreadsheet. There is a separate setting for the horizontal orientation, as well as the vertical orientation. Read more about ways to fix printing issues, such as getting your spreadsheet to fit to the page more easily, or clearing a print area.
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 tiny Page Setup dialog launcher at the bottom-right corner of the Page Setup section in the ribbon.
Step 4: Click the Margins tab at the top of the window.
Step 5: Check the box to the left of Horizontally to center your printed spreadsheet horizontally on the page. Check the box to the left of Vertically to center it vertically on the page. If you then click the Print Preview button you can see how your printed spreadsheet will now look.
If you find that your data is difficult to read because you can’t see the cell boundaries, then click here to learn how to print gridlines. Additionally, if you are printing a multi-page spreadsheet, then printing titles can make it easier for your readers to identify cell locations.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.