Named Ranges in Excel

Named Ranges in Excel
A Named Range is way to describe your formulas. So you don't have to have this in a cell:
= SUM(B2:B4)
You can replace the cell references between the round brackets. You replace them with a descriptive name, all of your own. So you could have this, instead:
= SUM(Monthly_Totals)
Behind the Monthly_Totals, though, Excel is hiding the cell references. We'll see how it works, now.

  View Docs