Center Excel Spreadsheets for Printing
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
After
Sections:
Center Printed Data in Excel
- Go to the Page Layout tab > click Margins > at the bottom of the menu that appears, click Custom Margins...
- 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.
- Click OK and that's it!
You can also get to this screen by clicking the Margins menu from the Print Preview window.
Notes
Make sure to download the attached file to work with the above example.
Question? Ask it in our Excel Forum
(35% Sale Ends Jan. 26)
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.)
Tutorial: This tip shows you how to fit more Excel data onto a page for printing. This does not chan...
Tutorial: How to repeat specific rows or columns on every printed page so that you know what each c...
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Tutorial: How to print the comments in a worksheet when you print from Excel. This includes how to p...
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Tutorial: How to print the current date and or time on an Excel spreadsheet. This is a simple techni...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
(35% Sale Ends Jan. 26)
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.)