Tuesday, August 13, 2013

How to Print on One Page in Excel 2003


1. Click 'Start' from the bottom-left of the screen. Click 'All Programs' and then click 'Microsoft Excel 2003.'
2. Click 'File' and then 'Open.' Click the Excel file of choice and click 'Open.'
3. Click and drag the mouse over the group of cells of the worksheet you wish to print. If you do not choose the group of cells when you print, Excel will print both cells with data as well as cells that are blank.
4. Click 'File,' then click 'Print Area' and then 'Set Print Area.'
5. Click 'File' and then click 'Page Setup.'
6. Click the option 'Fit to' in the 'Page' tab. Enter the value of '1' page wide by '1' tall.
7. Click the 'Margins' tab. Check the box next to 'Horizontally' under 'Center on page' and click 'OK.' This ensures the worksheet prints in the center of the page for the standard portrait paper layout.
8. Click 'File' and then 'Print.' The Print window launches. Click 'OK' to print your worksheet.

Blogger news