en uk

Defining printing margins Microsoft Office 2007

    To help you squeeze or expand your spreadsheet to fill a printed page, you can define different margins for each printed page. To define margins, follow these steps:

    1. Click the Page Layout tab.

    2. Click the Margins icon in the Page Setup group.

    A pull-down menu appears, as shown in Figure 7-25.

    3. Choose a page margin style you want to use.

    If you choose Custom Margins in Step 3, you can define your own margins for a printed page.

    Defining printing
margins Microsoft Office 2007

    Figure 7-25:

    The Margins icon lists different predefined margins you can choose.

    Defining paper orientation and size

    Paper orientation can be either landscape (the paper width is greater than its height) or portrait mode (the paper width is less than its height). Paper size defines the physical dimensions of the page.

    To change the paper orientation and size, follow these steps:

    1. Click the Page Layout tab.

    2. Click the Orientation icon in the Page Setup group.

    A pull-down menu appears, as shown in Figure 7-26.

    Defining printing
margins Microsoft Office 2007

    Figure 7-26:

    The

    Orientation menu lets

    You choose Portrait or

    Landscape mode.

    3. Choose Portrait or Landscape.

    4. Click the Size icon in the Page Setup group.

    A pull-down menu appears, as shown in Figure 7-27.

    5. Click a paper size.

    Defining printing
margins Microsoft Office 2007

    Figure 7-27:

    The Size menu lists different paper sizes you can use.

    Printing in Microsoft Excel 2007

    When you finish defining how to print your spreadsheet, you can either print right away or view a Print Preview of your spreadsheet just to make sure everything's going to print correctly.

    To print a spreadsheet right away, click the Office Button, click the right-pointing arrow that appears to the right of Print, and then choose Quick Print.

    To display the Print Preview before printing, follow these steps:

    1. Click the Office Button and then choose Print.

    The Print dialog box appears.

    2. Click the Preview button.

    The Print Preview window appears, as shown in Figure 7-28.

    If you click the Show Margins icon, the Print Preview window displays your page margins as dotted lines, which you can drag to move and redefine new page margins before printing.

    3. Click Close Print Preview (to close the Print Preview window) or Print (to close the Print Preview window and print your spreadsheet).

    Defining printing
margins Microsoft Office 2007

    Figure 7-28:

    The Print Preview window displays your spreadsheet exactly how it will look when you actually print it.

    Playing with Formulas

    Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of a second-order differential equation.

    Formulas use data, stored in other cells, to calculate a new result that appears in another cell. To create even more complicated spreadsheets, you can even make a formula use data from other formulas so that changes in a single cell can ripple throughout an entire spreadsheet.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.