How do you perform the commands to center the selected worksheets both horizontally and vertically?

1 answer

Answer

1093953

2026-08-12 18:20

+ Follow

To center selected worksheets both horizontally and vertically in Excel, first, select the worksheets you want to modify by holding down the Ctrl key and clicking on each tab. Next, go to the “Page Layout” tab on the ribbon, and click on the small arrow in the bottom right corner of the "Page Setup" group. In the Page Setup dialog, navigate to the "Margins" tab, and under "Center on page," check both the "Horizontally" and "Vertically" options, then click "OK." This will ensure that your selected worksheets are centered when printed.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.