How to center worksheet horizontally and vertically in Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-center-worksheet-horizontally-and-vertically-in-Excel.png)
Excel offers a very interesting way to center a worksheet horizontally and vertically. We can cater to this problem statement by exploring the Page Layout option in excel. We can perform the below mentioned way to center a worksheet horizontally and vertically in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-center-worksheet-horizontally-and-vertically-in-Excel.png)
– Open the desired Excel workbook in which you want to center the page horizontally
Step 2 – Exploring the Page Layout option
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-center-worksheet-horizontally-and-vertically-in-Excel.png)
– Now in the page layout option, click on the “Margins” options and then select “Custom Margins”.
Step 3 – Page Setup dialogue box
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-center-worksheet-horizontally-and-vertically-in-Excel.png)
– A dialogue box would appear, click on the “Horizontally” and “Vertically” options under Center on page and then hit Enter.
Step 4 – Worksheet centered horizontally and vertically
![](https://spreadcheaters.com/wp-content/uploads/Step-4-How-to-center-worksheet-horizontally-and-vertically-in-Excel.png)
– We can see that the worksheet has been centered horizontally and vertically