Keep your range names so they are easy to understand and find by using the structured prefix described in another tip and adding a military or hierarchical naming convention. To do that, type the largest grouping of items as the first part of the name. For example, if you have range of names describing the revenue from geographic regions you might use names like,
By looking at those names you know they are a value for revenue from a specific region.
Related content are,