How to ‘Center on Page’ Print in Excel

by

To center a range of cells on a printed page in Excel automatically, execute the following steps.

Worked Example:   How to set or clear a print area in Excel Worksheet

1. On the File tab, click Print.

Worked Example:   How to make excel worksheets print on one page?

2. Click ‘Custom Margins’ from the Margins drop-down list.

Worked Example:   Print Gridlines and Headings in Excel

3. Next, check horizontally and vertically.

4. Click OK.

Leave a Reply

Your email address will not be published.