Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

How to ‘Center on Page’ Print in Excel

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

Worked Example:   How to setup and print Excel worksheets

1. On the File tab, click Print.

Worked Example:   Print Gridlines and Headings in Excel

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

Worked Example:   Print Headers and Footers in Excel

3. Next, check horizontally and vertically.

4. Click OK.

Leave a Reply

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