Labelling a range of cells

  • Thread starter Thread starter gary
  • Start date Start date
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).
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

useform label enter 1
Named range labels in formulas 1
how do i average the totals of multiple cells, that have the same label 5
Activating hyperlinks 3
Trying to run excel vba code when cell value changes from empty to entered value. 1
Chart custom labels 1
VBA set thick borders around non empty cells in range 0
Data Labels Disappearing 0

Back
Top