Working with Ranges

[ LiB ]

A range name is basically a descriptive name for an area of the worksheet. Range names are much easier to remember than actual cell addresses. You can use range names in formulas or commands such as Go To.

Creating Range Names

Giving cells recognizable range names makes locating data easier. It also can help make formulas more logical and easier to understand.

NOTE

Ranges can be a single cell, a contiguous group of cells, entire rows, or entire columns .

• Range names must begin with a letter or the underscore character.

• Range names cannot include a space or a hyphen.

• Range names are not case sensitive. You can use uppercase or lowercase letters .

• Range names can be up to 255 characters , but shorter is better.

Using Range Names

Range names can help you jump quickly to specific areas of your worksheet. You can also use range names when creating Excel formulas.

Excel provides a convenient drop-down menu that you can use to quickly move around in your worksheet. Moving to remote areas of your worksheet can be a mouse click away using range names.

[ LiB ]