Friday, October 14, 2011

How to Center Worksheets Both Horizontally Vertically in Windows Excel


1. Open your worksheet in Microsoft Excel by clicking the 'Office' button in the upper left corner and selecting 'Open.' Navigate to where your workbook is located and click 'Open' to display the worksheet.
2. Click the 'Page Layout' tab and click 'Margins' in the 'Page Setup' group
3. Click 'Custom Margins' to display the 'Page Setup' settings.
4. Check the boxes located next to 'Horizontally' and 'Vertically' under 'Center on Page' to center your worksheet. Click 'OK' to close the 'Page Setup' box.

Blogger news