unioncofl.com

Tech, how-to guides, and tutorials based out of Union County, FL

  • Excel 2013
  • About Us
  • Contact
You are here: Home / Excel 2013 / How to Horizontally Center a Worksheet When You Print It In Excel 2013

How to Horizontally Center a Worksheet When You Print It In Excel 2013

November 23, 2016 By Adam

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.

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.

open the page setup menu

 

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

click the margins tab

 

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.

how to center horizontally when printing in excel 2013

 

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.

Filed Under: Excel 2013

Recent Posts

  • How to Select All of the Cells in a Spreadsheet in Excel 2013
  • How to Horizontally Center a Worksheet When You Print It In Excel 2013
  • How to Remove Decimal Places from a Number in Excel 2013
  • How to Print Gridlines in Excel 2013
  • How to Hide a Worksheet Tab in Excel 2013

Archives

  • January 2017
  • November 2016
  • October 2016
  • August 2016
  • July 2016

Copyright © 2018 unioncofl.com