Monday, September 15, 2008

Naming Ranges: Why & How

Why
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.

How

  1. First highlight the range of cells you wish to name
  2. Now click inside the “Name” box on your toolbar at the upper-left of your screen
  3. Type your chosen name for the range
  4. Hit the Enter key and Presto! Your range is named. Give it a try!

No comments: