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

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...