Setting Printing Options

Few changes to a workbook are as noticeable as the options you select before printing. Using the Page Setup command on the File menu, you can control the orientation of your page, the width of your margins, the text placed in headers and footers, and the presence of extras like gridlines and cell notes. The Page Setup dialog box contains four tabs that control how printing options are printed. We'll cover each tab in this section.

TIP
You can also display the Page Setup dialog box by choosing Header And Footer from the View menu.

Controlling Page Orientation

To customize your printing options, choose Page Setup from the File menu. The Page tab, shown in Figure 19-3, lets you control orientation and other options related to the physical page you'll be printing on. Orientation governs the direction your worksheet appears on the printed page. Portrait, the default, is a vertical orientation designed for worksheets that are longer than they are wide. If your worksheet is too wide to fit on one page in this orientation, which is often the case, choose the Landscape option to orient your document horizontally.

The Scaling options let you reduce or enlarge your worksheet so that it fits in the specified number of pages. The percentage you type in the Adjust To text box is similar to the percentage you specify when you create custom views using the Custom Views command. This is discussed in "Saving Views Using the Custom Views Command". However, in this case, it affects the printed page, not the view on your screen.

The Paper Size and Print Quality options let you specify a custom paper size and printing resolution. These options are drawn from the settings of your selected Windows-based printer. To set the unique attributes of your printer, click the Options button in the Page Setup dialog box, and make your changes on the dialog box tabs.

click to view at full size.

Figure 19-3. The Page tab lets you adjust page orientation and other paper options.

Adjusting the Margins

The Margins tab of the Page Setup dialog box allows you to adjust the margins in your workbook. (See Figure 19-4.) Typical margin settings are 1 inch for the top and bottom, and .75 inch for the left and right. As you change the margins, Excel shows you in the preview window which margin in your document is affected. Customizing the margin settings is especially useful if you're printing on letterhead paper or other sheets that contain graphics or text you don't want to overprint.

If you want to center your worksheet between the margin settings, select the Horizontally check box at the bottom of the Margins tab to center the printout from left to right, or select the Vertically check box to center the printout from top to bottom.

click to view at full size.

Figure 19-4. The Margins tab gives you control over the placement of your worksheet relative to the edges of the paper you print it on.

Adding Headers and Footers

The Header/Footer tab of the Page Setup dialog box (see Figure 19-5) lets you add a header or a footer to your worksheet when it prints. Headers and footers typically contain reference information about a document, such as the worksheet name, the time or date, or the current page number. Excel permits you to pick headers and footers from a predefined list on the Header/Footer tab, or you can create your own custom entries by clicking the Custom Header or Custom Footer buttons.

click to view at full size.

Figure 19-5. The Header/Footer tab lets you choose a header or footer from a predefined list or create your own version.

The following steps show you how to choose predefined headers and footers from the Page Setup dialog box:

  1. From the File menu, choose Page Setup. (You can also choose Header And Footer from the View menu.) When the Page Setup dialog box opens, click the Header/Footer tab.
  2. To pick a new footer, click the Footer drop-down list box, and choose one of the formats listed. The first format— (None)— removes the footer. Note that commas between items separate the header or footer components, which will be aligned to the left, center, and right margins.
  3. click to view at full size.

    When you select a format (and release the mouse button), the footer is shown in the footer preview window below the closed list box.

  4. To pick a new header, click the Header list box, and choose one of the formats listed. Again, the (None) option removes the header from the document.
  5. Commas in the header show how the header will be organized on the page, while the header preview window below shows how it will look. After you set headers and footers, your screen should resemble the following:

    click to view at full size.

  6. When you're finished, click OK. When you print, the specified headers and footers will appear on each page of your document.

TIP
Delete All Headers and Footers

To remove all headers and footers from a document, select the (None) option in both the Header and Footer drop-down list boxes.

If you don't like the predefined headers and footers, you can create your own by clicking the Custom Header and Custom Footer buttons on the Header/Footer tab. The following steps show you how:

  1. From the File menu, choose Page Setup. When the Page Setup dialog box opens, click the Header/Footer tab.
  2. To create a custom header, click the Custom Header button. The dialog box shown below appears.
  3. click to view at full size.

    The Header dialog box lets you specify your header in three sections: left, center, and right.

  4. Click in one of the sections, and then type the text you want.

    You can supplement the text you type by clicking any of seven special buttons to enter codes in your document. For example, if you click the button on the right side of the group (the Worksheet Name icon), the code &[Tab] is placed in the header. This is Excel's special formatting code for inserting the name of the current worksheet of your workbook at this location in the header.

  5. To change the formatting of the text, select the portion you want to format, and click the Font button.
  6. When you're finished with the header, click OK to view the customized header in the preview window. If you don't like the results, repeat the above steps and make further changes.
  7. If you want to create a custom footer, click the Custom Footer button and follow steps 3 through 5 as you did for creating a custom header.
  8. When your header and footer are the way you want them, click OK.

TIP
To create multiline headers or footers, press Enter at the end of each line in the section portion of the Header or the Footer dialog box.

Adding Gridlines and Other Options

The Sheet tab of the Page Setup dialog box (see Figure 19-6) lets you include visual or interpretive aids such as gridlines, comments, and repeating row and column headings in your printout. Gridlines are the dividing lines you normally see on your screen that run down each column and across each row, identifying the cells in the worksheet. To print gridlines with your worksheet, simply select the Gridlines check box in the Print category. Cell comments are special notes you create by using the Comments command on the Insert menu. You can specify how they're printed by choosing a selection in the Comments list box. The default (None) is not to print any comments the worksheet might contain.

SEE ALSO
To learn more about using comments in your worksheet, see "Entering Comments".

TIP
To remove gridlines from your screen, choose Options from the Tools menu, click the View tab, and deselect the Gridlines check box.

click to view at full size.

Figure 19-6. The Sheet tab lets you include extras such as gridlines and cell comments in your printout.

Two other useful features on the Sheet tab are the Print Area and Print Titles text boxes. Both these features let you select ranges for printing. In the Print Area text box, you specify the worksheet range that will be printed. In the two Print Titles text boxes, you can choose to repeat either row or column headings (or both) on multipage printouts. To use the Print Area feature, follow these steps:

  1. From the File menu, choose Page Setup.
  2. When the Page Setup dialog box opens, click the Sheet tab.
  3. Click the Collapse Dialog button at the right edge of the Print Area text box. The dialog box will temporarily shrink to enable you to see your worksheet. If it still obscures your view, drag its title bar and move it out of the way.
  4. TIP
    To delete a print area, click the Sheet tab and delete the cell range in the Print Area text box. (This won't change your original data, only the way it prints.)

  5. Select the cells you want to print in the worksheet.
  6. As you select the cells, a marquee appears around the range, a pop-up box shows the number of rows and columns you're selecting, and a description of the cells appears in the Print Area text box, as shown here:

    click to view at full size.

  7. When you have selected the cells you want, click the Collapse Dialog button again.
  8. After making any other changes, click the Print button, and then click OK in the Print dialog box to print the cells you selected.

TIP
To delete a print area or to choose a different one (without changing your data), click the Sheet tab and delete the cell range in the Print Area text box. Leave it blank or draw a new range on your worksheet.

To repeat row or column headings (or both) on each printed page of a long (or wide) worksheet, follow these steps:

  1. Choose Page Setup from the File menu.
  2. When the Page Setup dialog box opens, click the Sheet tab.
  3. Click one of the Collapse Dialog buttons under the Print Titles heading to select repeating rows or repeating columns.
  4. Select the rows or columns you want to have repeated on each page. You can click any cells in the rows or columns you would like to have repeat, or you can select the row or column headings. Excel will highlight the entire rows or columns you select by surrounding them with a marquee.
  5. Click the Collapse Dialog button again to complete your selection.
  6. You can repeat steps 3–5 if you want to repeat both rows and columns on your printed worksheet.
  7. After making any other changes, click OK to close the Page Setup dialog box, or click the Print button, and then click OK in the Print dialog box to print the worksheet.

TIP
You can verify how your print options will look by clicking the Print Preview button in the Page Setup dialog box or by choosing Print Preview from the File menu. This allows you to decide whether to make cosmetic adjustments and to ensure that you have chosen the portion of the worksheet you want.


Running Microsoft Office 2000 Small Business
Running Microsoft Office 2000
ISBN: 1572319585
EAN: 2147483647
Year: 2005
Pages: 228
Authors: Michael Halvorson, Michael J. Young
BUY ON AMAZON

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net