Naming ranges in Excel can save you a lot of time and make your formulas more intuitive.
Using a named range in a formula does away with the need to make the range an absolute reference because it will always point to the correct range, regardless of where you copy the formula.
- First highlight the range of cells you wish to name
- Now click inside the “Name” box on your toolbar at the upper-left of your screen
- Type your chosen name for the range
- Hit the Enter key and Presto! Your range is named. Give it a try!