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.
To set the page horizontally and vertically, follow below mention steps:-
You can set the page horizontally and vertically manually following the below shown steps:-
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.