How to Center Excel Sheet Horizontally and Vertically on Page?

In this article, we will learn how to center a worksheet horizontally in Excel or how we can do center a worksheet in Excel.

To align the sheet center horizontally and vertically in Excel, we can change the margins through Page Setupoption. We can set the page from top, left, right, and bottom.

Let’s take an example and understand what command should be applied to center worksheet both horizontally and vertically?

I have data in range A1:B18. Now, I want the Excel to center horizontally and vertically on page.

 

image 1

To set the page horizontally and vertically, follow below mention steps:-

  • Go to the “Page Layout” tab.
  • Click on “Margins” in the “Page Setup” group.
  • Click on “Custom Margins” from dropdown.
  • The “Page Setup” dialog box will appear.
  • Click on the check boxes of “Horizontally” and “Vertically’.
  • Before clicking on OK, you can see “Print Preview”.

image 2

 

You can set the page horizontally and vertically manually following the below shown steps:-

  • Go to the “Page Layout” tab.
  • Click on “Margins” in the “Page Setup” group.
  • Click on “Custom Margins” from dropdown.
  • The “Page Setup” dialog box will appear.
  • Instead clicking on horizontally and vertically just decrease and increase the margins for Top, bottom, left and right.

image 3

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube