Microsoft® Office Excel® 2007 Plain & Simple

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 you want to use in your calculation, you can type in the name of the range. When you reference named ranges in formulas, your formulas will be shorter and easier to understand. Rather than seeing a series of cell references you need to examine, you and your colleagues can rely on the named ranges to understand the goal of a calculation.

Excel 2007 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 ...