en uk

Clearing Data Microsoft Office 2007

    After you create a spreadsheet, you may need to delete data, formulas, or just the formatting that defines the appearance of your data. To clear out one or more cells of data, formatting, or both data and formatting, follow these steps:

    1. Click the Home tab.

    2. Select the cell or cells that contain the data you want to clear.

    3. Click the downward-pointing arrow to the right of the Clear icon in the Editing group.

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

    Clearing Data Microsoft Office 2007

    Figure 7-19:

    The Clear menu provides dif­ferent ways to clear out a cell.

    4. Choose one of the following:

    Clear All: Deletes the data and any formatting applied to that cell or cells

    Clear Formats: Leaves the data in the cell but strips away any formatting

    Clear Contents: Leaves the formatting in the cell but deletes the data

    Clear Comments: Leaves data and formatting but deletes any com­ments added to the cell


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.