Should have said..........at least two columns.

The column(s) to the right of the desired names will be the named range.

The leftmost column cells will be the defined name.

i.e.

Column A

bert
gord
dima
pete

Data in columns B:F

Select A:F and InsertNameCreateLeft column

bert will refer to B1:F1
gord will refer to B2:F2


Gord



On Thu, 7 Aug 2008 22:41:00 -0700, Dima
wrote:

Thanks Gord Dibben for replying!
One of the "two columns" is the column with future row names, isn't it?
What is the second column?
Regards,
Dmitry
"Gord Dibben" wrote:

InsertNameCreate

Must have two columns selected.


Gord Dibben MS Excel MVP

On Thu, 7 Aug 2008 06:24:01 -0700, Dima
wrote:

Hello!
How to name many rows by values in a column on the same sheet all at once?
Regards,
Dmitry