Subscribe

Lesson 87 of 104 1 min Updated Completed

How to Center a Sheet on the Page

By default, Excel prints your data in the top-left corner of the page. To print it in the middle of the page instead:

  1. Click File > Print. Under Settings, click the margins list (Normal Margins) and choose Custom Margins.

    Choosing Custom Margins on the Print screen

  2. In the Page Setup dialog box, under Center on page, tick Horizontally and Vertically.

    Ticking Horizontally and Vertically under Center on page

  3. Click OK.

    The data centered on the page in the print preview

Result: the print preview shows your data in the center of the page.

Tip: For most tables, Horizontally alone looks best, since it keeps the table near the top of the page.