Microsoft Office Tutorials and References
In Depth Information
Using Names to Work with Ranges
If you click the Paste Link button in the Paste Special dialog box, you create formulas that link to the source range.
As a result, the destination range automatically rel ects changes in the source range.
Using Names to Work with Ranges
Dealing with cryptic cell and range addresses can sometimes be confusing, especially when
you deal with formulas, which are covered in Chapter 15. Fortunately, Excel allows you to
assign descriptive names to cells and ranges. For example, you can give a cell a name such
as Interest_Rate, or you can name a range JulySales. Working with these names (rather
than cell or range addresses) has several advantages:
A meaningful range name (such as Total_Income) is much easier to remember
than a cell address (such as AC21).
Entering a name is less error prone than entering a cell or range address, and
if you type a name incorrectly in a formula, Excel will display a #NAME? error.
You can quickly move to areas of your worksheet either by using the Name box,
located at the left side of the Formula bar (click the arrow to drop down a list of
defi ned names) or by choosing Home Editing Find & Select Go To
(or pressing F5) and specifying the range name.
Creating formulas is easier. You can paste a cell or range name into a formula
by using Formula AutoComplete, another feature covered in Chapter 15.
Names make your formulas more understandable and easier to use. A formula
such as =Income—Taxes is more intuitive than =D20—D40 .
Creating range names in your workbooks
Excel provides several different methods that you can use to create range names. Before
you begin, however, you should be aware of a few rules:
Names can’t contain any spaces. You may want to use an underscore character to
simulate a space (such as Annual_Total).
You can use any combination of letters and numbers, but the name must begin
with a letter, underscore, or backslash. A name can’t begin with a number (such
as 3rdQuarter) or look like a cell address (such as QTR3). If these are desirable
names, though, you can precede the name with an underscore or a backslash: for
example, _3rd Quarter and \QTR3.
Symbols — except for underscores, backslashes, and periods — aren’t allowed.
Names are limited to 255 characters, but it’s a good practice to keep names as
short as possible, but still meaningful.
Search JabSto ::

Custom Search