Conventions for naming ranges

Use the following conventions when naming a range.



Name length

Range names can be up to 15 characters long.



Case-sensitivity in names

Range names are case-sensitive. For example, "myrange" and MYRANGE are not considered to be the same name and can refer to two different ranges.



Character restrictions

Names for ranges cannot contain spaces. Also, do not start a name with an ! (an exclamation point), and do not include any of the following characters in a range name:

, (comma) + (plus sign) < (less than)
; (semicolon) - (minus sign) > (greater than)
. (period) * (asterisk) @ (at sign)
? (question mark) / (slash) # (pound sign)
& (ampersand) { (left curly brace)


Naming restrictions

Do not create names that look like cell addresses, such as Q2 or FY96; or names that begin with numbers, such as 20DEC. Do not use @function names or keyboard key names, such as HOME, as range names.