Using descriptive named ranges in formulas can make your formulas easier to understand. To use a named range in a formula, simply replace the cell reference you would normally use with the range name. For example, suppose we had the cell range A1:15 named 1999_Total and the cell range B1:B15 named 2000_Total. To find the sum of those two cell ranges, we could use the formula:
=1999_Total + 2000_Total
To Use a Named Range:
- Select the cell that will contain the formula.
- Type the formula, substituting a named range for the cell address where appropriate.
Or
Drag-select the range you want to use in your worksheet. Excel will enter the range name for you.
Or
Click the Use in Formula button on the Defined Names group of the Formulas Ribbon and select the named range you want to use. - Press Enter to confirm the entry.
Tip: When beginning to type the name of the range, a small box will appear with the complete range name. This is an example of Excel’s AutoComplete feature. Press the Tab key to finish inserting the range name.
Similar Posts:
- None Found
Comments on this entry are closed.