• Skip to main content
  • Skip to primary sidebar

Master Your Tech

Mobile phones, software, consumer electronic how-to guides

  • iPhone
  • Excel
  • Powerpoint
  • Word
  • Google Drive
  • Tech
  • Guides
You are here: Home / Excel / How to Center Horizontally When Printing in Excel

How to Center Horizontally When Printing in Excel

posted on April 16, 2019

Excel is such a useful application that you can find yourself incorporating it into many elements of both your personal and professional life. Whether you’re balancing a budget or creating a sales report, Excel can make sure that you do it effectively and efficiently.

But one area where Excel doesn’t shine is how a spreadsheet looks when you print it with the default settings. It can be difficult to read, and it simply doesn’t look very good. One of the steps you can take to improve this, however, is to make sure that your spreadsheet is centered horizontally on the page. This is especially helpful when you have a sheet that only has a few thin columns, as they would be printed along the left edge of the paper by default.

How to Center Horizontally When Printing in Excel

The steps in this guide were performed in Microsoft Excel for Office 365. By changing the setting in this article you will be centering your entire spreadsheet on the printed page. We are focusing specifically on centering that spreadsheet horizontally, but the option to center vertically is also located on the same menu.

Step 1: Open your spreadsheet in Excel.

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

select the page layout tab

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

click the page setup button

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

select the margins tab

Step 5: Check the box to the left of Horizontally, then click the OK button.

how to center horizontally when printing in excel for office 365

The method above for centering your page horizontally is just one of many that can make your spreadsheet look better when you print. Another easy change to make is printing your spreadsheet’s gridlines. This makes data much easier to read, especially if there’s a lot of similar numbers on the page.

Matthew Burleigh
Matthew Burleigh

Matthew Burleigh has been a freelance writer since the early 2000s. You can find his writing all over the Web, where his content has collectively been read millions of times.

Matthew received his Master’s degree in Computer Science, then spent over a decade as an IT consultant for small businesses before focusing on writing and website creation.

The topics he covers for MasterYourTech.com include iPhones, Microsoft Office, and Google Apps.

You can read his full bio here.

Share this:

  • Share on X (Opens in new window) X
  • Share on Facebook (Opens in new window) Facebook

Related posts:

  • How to Center Worksheet Horizontally and Vertically in Excel: A Step-by-Step Guide
  • How to Stop Document Properties from Printing in Word 2013: A Guide
  • How to Make My HP Laserjet P2055 Stop Printing Extra Pages
  • How to Enable the Control Center on the Lock Screen on an iPhone 7
  • How to Add or Remove a Screen Recording Button on the iPhone 7 Control Center
  • How to Center Text in the Middle of the Page in Word for Office 365
  • How to Sort the Notification Center By Time on Your iPhone
  • How to Add a Vertical Line at the Center of Google Slides: Step-by-Step Guide
  • How to Vertically Center Text in Word: 2024 Guide for Perfect Alignment
  • How to Find the Difference in Excel for Office 365
  • How to Insert Bullet List Items in Excel 2010: A Step-by-Step Guide
  • Why Is Excel Showing ######? Understanding Number Display Errors

Filed Under: Excel

Search

Primary Sidebar

Latest Posts

  • How to Link Windows Key to Microsoft Account: A Step-by-Step Guide
  • How to Find Serial Number on Windows 11: A Step-by-Step Guide
  • How to Disable Automatic Restart on Windows 11: A Step-by-Step Guide
  • How to Password Protect a Folder in Windows: A Step-by-Step Guide
  • How to Download Android Apps on Windows 11: A Step-by-Step Guide
  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2026 MasterYourTech.com