Microsoft Office Tutorials and References
In Depth Information
Using names in formulas
Using names in formulas
When you define a named range, you create a shortcut that you
can use to refer to a group of cells. A great way to use named
ranges is in formulas. Instead of entering the references of
every cell that you want to use in your calculation, you can type
the name of the range. When you reference named ranges in
formulas, your formulas are shorter and easier to understand.
Rather than seeing a series of cell references that you need to
examine, you and your colleagues can rely on the named ranges
to understand the goal of a calculation.
Excel 2013 further streamlines formula creation with Formula
AutoComplete. Remember that when you start typing a value
into a cell, Excel examines the previous values in that column
and offers to let you complete the entry by pressing Tab or
Enter. Now, when you start typing a named range’s name into a
formula, Excel recognizes that you might be entering a named
range and displays a list of named ranges (as well as built-in
functions) available in the active workbook. All you have to do
is click the named range that you want, and it’s included in the
formula immediately.
Create a formula with a named range
1 Click the cell in which you want to enter a formula.
2 Type = followed by the formula that you want. When you want to
use a range that has a name, start typing the name instead of the
cell address.
3 Click the named range in the Formula AutoComplete list that
appears.
4 Press Enter.
2 1
3
TIP If you change the name of a range of cells, Excel
automatically makes the name change in every one of your formulas.
Search JabSto ::




Custom Search