en uk

Naming cells Microsoft Office 2007

    One problem with the Go To command is that most people won't know which cell contains the data they want to find. For example, if you want to view the cell that contains your total amount of money you owe for your income taxes, you probably don't want to memorize that this cell is G68.

    To help you identify certain cells, Excel lets you give them descriptive names. To name a cell or range of cells, follow these steps:

    1. Select the cell or cells that you want to name.

    2. Click in the Name box, as shown in Figure 7-12.

    3. Type a descriptive name without any spaces and then press Enter.

    Naming cells Microsoft Office 2007

    Figure 7-12:

    You can type a descriptive name foryour cells in the Name box.

    After you name a cell, you can jump to it quickly by following these steps:

    1. Click the downward-pointing arrow to the right of the Name box.

    A list of named cells appears.

    2. Click the named cell you want to view.


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.