» Range Name Syntax
CATEGORY - Excel Range Name
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Microsoft Access 2002 for Dummies
- Marketing Plans That Work, Targeting Growth and Profitability
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Accounting for Dummies
- The Basics of Finance: Financial Tools for Non Financial Managers
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
