Center Excel Spreadsheets for Printing

Download Project Files
Author: | Edits: don

How to center the data that you print from Excel.

This means that worksheets that don't fill up an entire printed page will now be displayed nicely in the center of the page instead of in the upper-left corner.

Before

9c79612fe943e8c8528737501b8f6eba.png

After

eab193dd956b89638585d1cca87d70e0.png

Sections:

Center Printed Data in Excel

Notes

Center Printed Data in Excel

  1. Go to the Page Layout tab > click Margins > at the bottom of the menu that appears, click Custom Margins...
    f9824a111ed9a2ecd8655d3a21417c41.jpg
  2. In the window that appears, make sure you're on the Margins tab and check the boxes at the bottom next to Horizontally and Vertically.
    1881d23af7d1f8d65679c0e7e7b8aca1.jpg
  3. Click OK and that's it!

You can also get to this screen by clicking the Margins menu from the Print Preview window.

7e53f3740c372977997d3b2f002f0ee1.jpg

Notes

Make sure to download the attached file to work with the above example.

Download the Project Files

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Question? Ask it in our Excel Forum

Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Scale Data for Printing in Excel - Fit more onto a Printed Page
Tutorial: This tip shows you how to fit more Excel data onto a page for printing. This does not chan...
Print Specific Rows or Columns on Each Page in Excel
Tutorial: How to repeat specific rows or columns on every printed page so that you know what each c...
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Print Comments in Excel
Tutorial: How to print the comments in a worksheet when you print from Excel. This includes how to p...
Print the Current Date or Time in Excel
Tutorial: How to print the current date and or time on an Excel spreadsheet. This is a simple techni...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Tutorial Details
Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course