Formulas -> Defined Names->Define Name There was
a Dr. Seuss story about a Mrs. McCave who had 23 sons and named them
all "Dave." She could have named one "Buffalo Bill" and one "Buffalo
Bluff",...and one "Zanzibar Buck-Buck McFate." But she didn't, and
now it's too late. It was a good story about names.
Let's talk about names. The
Defined Names should make sense if someone else is trying to
edit or update your spreadsheet. There are also rules for what is and
is not allowed for names. Syntax
Rules for Defined Names The
first character must be a letter. The next characters can be
text, numbers, periods and underscores. Names can be up to 255
characters. Names
cannot include Cell References. For example, a Name cannot be
$B$1. Names cannot include "C", "c", "R", or "r" because they are
used as shorthand for selecting Columns and Rows in the Name Box.
Spaces are not allowed.
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.6. Apply cell ranges in formulas:
Define a Named Range |
|
| |
