1. Open the Excel file that contains the worksheet that you want to align horizontally and vertically. Click the appropriate worksheet.
2. Click the 'File' menu and select the 'Page Setup' option, which opens a separate window. Click the 'Margins' tab on the Page Setup window.
3. Click the 'Horizontally' and 'Vertically' check boxes under the Center on Page section.