en uk

Excel displays your chosen cell Microsoft Office 2007

    Eventually, you may want to edit or delete a name for your cells. To delete or edit a name, follow these steps:

    1. Click the Formulas tab.

    2. Click the Name Manager icon.

    The Name Manager dialog box appears, as shown in Figure 7-13.

    Excel displays
your chosen cell Microsoft Office 2007

    Figure 7-13:

    The Name Manager dialog box lets you rename or delete previously named cells.

    3. Edit or delete the named cell as follows:

    To edit the name, click the cell name you want to edit and then click the Edit button. An Edit Name dialog box appears, where you can change the name or the cell reference.

    To delete the name, click the cell name you want to delete and then click the Delete button.

    4. Click Close.

    Searching a Spreadsheet

    Rather than search for a specific cell, you may want to search for a particular label or number in a spreadsheet. Excel lets you search for the following:

    Specific text or numbers

    All cells that contain formulas

    All cells that contain conditional formatting




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.