In Excel page setup options can help you make your worksheet look more professional. Learn all about using the page setup feature in Excel here.
The page margins define where on the page Excel will print the worksheet. By default, the top and bottom margins are set at 1 inch in Excel 2003, while the left and right margins are set at .75 inch. Margin settings can be changed to whatever you want. Different margins can be defined for each worksheet in the workbook.
The Page tab of the Page Setup dialog box lets you change page orientation (portrait or landscape) or paper size (letter size or legal size). The default paper size in Excel 2003 is 8.5 x 11 inches, with a portrait orientation (prints up and down on the long side of the page). A landscape orientation, on the other hand, prints up and down on the short side of the page.
The Page tab of the Page Setup dialog box lets you shrink the spreadsheet data so it fits on a specified number of pages when you print. Click the Fit to: option button, and enter the desired number of pages wide and pages tall.
The Page tab of the Page Setup dialog box lets you define the resolution of the print job. Print quality is measured in dpi, or dots per inch. High dpi provides a better print quality.
Headers and footers can be added to any worksheet, although they are not required. A header is any information that appear at the top of each page, while a footer prints at the bottom of the page. If you want a header or footer inserted onto a page, you will have to define them. Excel 2003 defaults to no header and no footer.
You can insert placeholder buttons into both the header and footer to format text and insert page numbers, dates, times, file names, and tab names. Excel replaces these placeholders with the information each represents when the worksheet is printed. Follow the instructions in the Header and Footer dialog boxes.
The Sheet tab in the Page Setup dialog box provides additional print options that you may want to add to your worksheet.
By default, Excel prints from the A1 to the last occupied cell in a worksheet. You can specify a different range of cells to print.
Prints column and row labels on each page of the printout. Specify these rows or columns in the Rows to Repeat at Top and Columns to Repeat at Left textboxes.
This determines whether gridlines are printed. However, turning off gridlines does not affect their appearance in Normal View.
If you used colors in your worksheet but don't want to waste the ink in your color printer, use black and white.
Choose draft quality to print the worksheet without gridlines or graphics.
Click this option to include row numbers and columns letters in your printed document.
This determines the order in which worksheets are printed.