Tip:
Highlight text to annotate it
X
Hi, I'm Amar Enhsaihan, I'm going to show you how to define range names in Excel. I
have my example open. I am going to highlight the range that I'm going to name and then
insert name, define, I'll name it as, anything you want. Numbers, so since we named this
range, now we don't have to use the actual cell of references, we can just use a name.
Check this out, I'm going to sum it up, sum up the range, sum, open parentheses, numbers,
closed parentheses, and wa-la, one forth nine, sum of this range. That's how you create range
names in Excel. I'm Amar Enhsaihan, thank you for watching!