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
Posted by paiya
on 05:48.
Filed under
Spreadsheet Tutorials
.
You can follow any responses to this entry through the RSS 2.0