Use a Major and Minor Naming Convention when Naming Ranges

Excel

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,

valRevEast

valRevWest

valRevNorth

valRevSouth

By looking at those names you know they are a value for revenue from a specific region.

Related content are,

Quickly Create Range Names

Use Only Allowed Characters in Range Names

Create Range Names with Upper and Lower Case, but Type them in Lower Case as a Cross-Check

Use a Structured Prefix to Identify Range Name Types

 

Share the power...