Tuesday, November 27, 2012

How to Perform the Command to Center a Worksheet Both Horizontally Vertically


Excel 2003
1. Log on to your computer and open Excel 2003. Click the 'File' menu and choose 'Page Setup.'
2. Click the 'Margins' tab. Go to the 'Center on Page' section.
3. Check both the horizontal and vertical check boxes. Click 'OK' to print your centered worksheet.
Excel 2007
4. Open Microsoft Excel 2007 and open the spreadsheet you want to center. Click the Office button on the upper-left corner of the screen. Go to the 'Print' menu and select 'Print Preview.'
5. Choose the 'Page Setup' option and click the 'Margins' tab. Check the 'Horizontally' and 'Vertically' boxes in the 'Center on page' section. Click 'OK' to close the 'Page Setup' menu. Review the print preview of the document to make sure that it is properly centered.
6. Click 'Print' to send your centered spreadsheet to the printer. Click 'Close Print Preview' to return to the main screen.
Open Office Calc
7. Log on to your computer and open the Open Office Calc program. Click 'File' and then 'Open.'
8. Select the spreadsheet you want to center. Click the 'Format' menu and choose 'Page.'
9. Click the 'Page' tab. Check the 'Horizontal' and 'Vertical' checkboxes and click 'OK' to save the settings.

Blogger news