Thursday, January 27, 2011

How to Use Page Setup in Microsoft Excel 2003


1. Access the page setup menu. To access the page setup menu scroll to the “File” tab on the command bar and select “Page Setup.”
2. Set the “Page” tab preferences. You can set the printing options to either portrait or landscape under this tab, which will print the sheet either vertically or horizontally. You can also set the scaling so the sheet will shrink to print on a single page under the “Scaling” section. Finally, you can set the paper medium and the print quality using the corresponding drop-down menus.
3. Set the “Margins” tab preferences. Under this tab, you can specify the width of the top, left, right, bottom and header and footer margins by typing in the desired margin widths into their corresponding boxes. You can also determine whether the page prints centered, either horizontally or vertically, by checking the corresponding boxes.
4. Set the “Header/Footer” tab preferences. Under this tab, you can type in the desired header and footer text. To add images and links to the header and footer, click on the “Custom Header” or the “Custom Footer” boxes and add the desired images and links.
5. Set the “Sheet” tab preferences. Under this tab, you can determine the sheet preferences for printing. You can set the print area, rows to repeat at the top and columns to repeat to the left by typing in the desired row and column information into the corresponding boxes. You can also specify the print quality, whether or not the printed sheet contains gridlines, is black and white or color and whether or not it includes any comments by checking the corresponding boxes. Finally, you can determine the page order of the printing by selecting the corresponding radial buttons.
6. Implement changes. To implement the page setup changes, click on the “OK” button.

Blogger news