How to Center Worksheet Horizontally in Microsoft Excel

April 3, 2026·1 min read

In this article

Interactive demo
Step-by-step guide
FAQ
Similar tutorials

Made with Saltfish·Create your own

Here's how to center worksheet horizontally in MS Excel

Navigate to the Page Layout tab located in Excel's ribbon menu.
Click on the Margins button in the Page Setup group.
Choose Custom Margins from the dropdown menu options.
Locate the Center on Page section in the dialog box.
Check the Horizontally checkbox and click OK to apply the centering.

Ready to get started with
interactive demos?

Try for free

Frequently Asked Questions

Will centering my worksheet horizontally affect how it displays on screen?

No, horizontal centering only affects the printed version and print preview of your worksheet. Your data will continue to display normally in the regular Excel view on your screen.

Can I center my worksheet both horizontally and vertically at the same time?

Yes, you can check both the Horizontally and Vertically boxes in the Center on Page section. This will center your worksheet content both ways on the printed page for perfect alignment.

Does horizontal centering work for all worksheet sizes and data ranges?

Yes, Excel's horizontal centering feature automatically adjusts to your data range regardless of how much content you have. It calculates the center point based on your actual worksheet content and available page space.

How to Center Worksheet Horizontally in Microsoft Excel

Here's how to center worksheet horizontally in MS Excel

Frequently Asked Questions

Similar tutorials

How to Add a Date Picker Calendar to Cells in MS Excel

How to Create Salary Sheet in MS Excel

How to Create Marksheet in MS Excel