Center on Page 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.

Click Custom Margins

3. Next, check Horizontally and Vertically.

Center on Page

4. Click OK.

Print Preview

If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.