Naming a Range

To make working with ranges easier, Excel allows you to name them. The name Sales, for example, is easier to remember than the coordinates B4:D10. You can use named ranges in formulas the same way you use cell references and range addresses. Named ranges can be helpful when navigating larger worksheets.

Name a Cell or Range

graphics/one_icon.jpg

Select the cell or range you want to name.

graphics/two_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. A range name cannot include spaces in the name. Try to use a simple name that reflects the information in the range, such as VendorNames.

graphics/four_icon.jpg

Press Enter. The Name box shows the name whenever you select the range.

graphics/08inf04.jpg

Select a Named Cell or Range

graphics/one_icon.jpg

Click the Name box list arrow on the formula bar.

graphics/two_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/08inf05.jpg

Did You Know?

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



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

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