Section: Naming Ranges
...Subsection: Why name a cell or cells?

The key to the increased readability is the use of named ranges. Once you've named a range, you can use the name in all of your formulas for increased readability.

At first glance, naming ranges seems like a waste of time. It isn't. Why bother to name ranges?

• Names are just plain easier to understand than something like A1:A10.
• It's really hard to read formulas when the cells they reference are off-screen. Larger spreadsheets, that take up more than one screen on the computer, are much harder to follow without names because you can't always see the cells you're referencing.
• While your spreadsheet might make perfect sense to you, in a business setting there's no guarantee that you will be the one maintaining the spreadsheet. No matter what you do on a computer, always do your best to make sure someone else could figure it out.