Naming Cells and Ranges

Naming Cells and Ranges

graphics/microsoft09.gif

To make working with ranges easier, Excel allows you to name them. The name BookTitle , for example, is easier to remember than the range reference B6:B21. Named ranges can be used to navigate large worksheets. Named ranges can also be used in formulas instead of typing or pointing to specific cells. If the cell or range you want to name has labels, you can have Excel automatically name the cell or range for you. If you have already entered a cell or range address in a formula or function, you can apply a name to the address instead of re-creating it.

Name a Cell or Range

graphics/one_icon.jpg

Select the cell or range you want to name.

graphics/tow_icon.jpg

Click the Name box on the formula bar.

graphics/three_icon.jpg

Type a name for the range. A range name can include uppercase or lowercase letters , numbers , and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle .

graphics/foure_icon.jpg

Press Enter. The range name will appear in the Name box whenever you select the range.

graphics/03inf12.jpg

Select a Named Cell or Range

graphics/one_icon.jpg

Click the Name box list arrow on the formula bar.

graphics/tow_icon.jpg Click the name of the cell or range you want to use.

The range name appears in the Name box, and all cells included in the range are highlighted on the worksheet.

graphics/03inf13.jpg

Let Excel Name a Cell or Range

graphics/one_icon.jpg

Select the cells, including the column or row header, you want to name.

graphics/tow_icon.jpg

Click the Insert menu, point to Name, and then click Create.

graphics/three_icon.jpg Select the check box with the position of the labels in relation to the cells.

Excel automatically tries to determine the position of the labels, so you might not have to change any options.

graphics/foure_icon.jpg

Click OK.

graphics/03inf14.jpg

Apply a Name to a Cell or Range Address

graphics/one_icon.jpg

Select the cells in which you want to apply a name.

graphics/tow_icon.jpg

Click the Insert menu, point to Name, and then click Apply.

graphics/three_icon.jpg

Click the names you want to apply.

graphics/foure_icon.jpg

Click OK.

graphics/03inf15.jpg

Did You Know?

Should I select the Use Row And Column Names option ? When you select this option, Excel uses the range row and column headings to refer to the range you've selected (if a cell does not have its own name but is part of a named range).

You can delete a name range . Click the Insert menu, point to Name, click Define, select the range name, and then click Delete.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

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