How to Center a Spreadsheet when Printing in Excel

When a small worksheet is printed for sharing by PDF or printing on paper, it will appear in the upper left corner of the page like this:


A more professional presentation would center the information on the page. In Page Layout, there are options to center horizontally, vertically or both:

1. Click on the drop down arrow of Margins in the Page Layout tab. Select Custom Margins.


2. Click on the Margins tab and then check Horizontally, Vertically, or both. Then click OK.


In this example, centering horizontally looked best.


Leave a Reply

Your email address will not be published. Required fields are marked *