Labelling a range of cells

G

gary

How can I assign a "label" to a range of cells?

Using EDIT/REPLACE, I'd enter a particular value in the
"Find What" box and enter the "label" in the "Replace With"
box. (By doing this, the range of cells would then be
pasted in the appropriate cells).
 
G

Gord Dibben

gary

Labels don't work that way.

See Help Answer Wizard under "label ranges"(no quotes)

See also my answer to your other posting about "labels"

Gord Dibben Excel MVP
 
Top