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


When you create range names use upper and lower case lettering. For example, rngDataEntry. Excel remembers the upper and lower cases.

When you enter a range name in a formula, enter it as lower case, for example, rngdataentry. After you press Enter Excel will change the cases to match the original definition. In this case, rngDataEntry. If the cases don’t change, then you know you’ve mistyped or haven’t created the range name.

Related content are,

Quickly Create Range Names

Use Only Allowed Characters in Range Names

Use a Structured Prefix to Identify Range Name Types

Use a Major and Minor Naming Convention when Naming Ranges