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:

Formatting_2

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.

Centering_on_Page_2

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

Centering_on_Page_3

In this example, centering horizontally looked best.

Centering_on_Page_4

Leave a Reply

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