HomeMicrosoft OfficeExcelCenter on Page in Microsoft Excel

Center on Page in Microsoft Excel

This post will explain how you can center a range of cells on a printed page in Microsoft Excel automatically in a step by step manner.

When you print a page in excel it is by default right-aligned as the Normal margin settings are, you can change the margins to center on the page when you print.

How to Center on Page in Excel?

Follow the below steps to center a range of cells on a printed page in excel

  • Select the worksheet and navigate to the File tab and then Click on Print.
Center on Page in Excel
  • Click on Normal margins under Settings and then select Custom Margins, a Page Setup dialog box opens up.
Center on Page in Excel
  • In the Margins tab, under Center on Page check Horizontally and Vertically. Then Click OK button.
Center on Page in Excel
  • Immediately you can see that the page has been centered in the Print preview.
Center on Page in Excel

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021