|  

» Range Name Syntax

Name syntax rules:

The Name string must begin with a text character, not a number, and consists of adjacent characters.
Two words can be joined with an underscore (_), for example, to enter the Name "Excel Book", you should type Excel_Book.
You cannot use a Name that could otherwise be confused as a cell reference, for example, A1 or IS2002, as these are already cell references.

Notes:
There is no limit on the number of Names you can define.
Be sure to define unique Names for a specific workbook. Defining Names that resemble Names in other sheets will only complicate your work.
Screenshot // Range Name Syntax
Range Name Syntax


Rate This Tip
12 34 5
Rating: 2.14     Views: 44163
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments