Formulas -> Defined Names->Define Name

Rules for Defined Names

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