One mo
Select A1:B3
Insert|Name|Create
Check Left Column and uncheck all the others.
Click ok.

Lamb Chop wrote:

How can I do a batch naming of a series of cells by the cells next to them.

e.g.

A1 = apple B1=10
A2= orange B2=12
A3= banana B3=5

I want to name B1 to apple, B2 to Orange and B3 to banana.

At the moment, I enter them manually. Are there any better way?

Thanks in advance.



--

Dave Peterson