Center on Page

 

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

1. On the File tab, click Print.

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

Click Custom Margins

3. Next, check horizontally and vertically.

Center on Page

4. Click OK.

Print Preview