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.

3. Next, check horizontally and vertically.

4. Click OK.

.