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.
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.