January 16, 2012
One major convenience of using a named range in your formula, instead of a set of cell addresses, is that the formula makes more sense to math challenged people (like me!). It is also easier to create formulas on different worksheets, like summary sheets.
- To name a range of cells, highlight the cells first, and then right click on the highlighted cells.
- From the drop down box, select Define Name, then type in a name and hit OK.
- Click in the cell which will contain the formula, and start typing the formula.
- Put your cursor at the point where you will insert the named range, then click the Formula tab.
- In the Defined Names group, click the little arrow next to Use in Formula, and then select the named range.
- Finish your formula and hit Enter.