Could someone please explain the difference between Name/Define and
Name/Create under the Insert Menu?

Many thanks.

zhj23

NameDefine is used to define a range and give it a name like MyRange

NameCreate is to used to re-define existing row and column labels to names.

From Help.............................

Convert existing row and column labels to names

Select the range you want to name, including the row or column labels.
On the Insert menu, point to Name, and then click Create.
In the Create names in box, designate the location that contains the labels by
selecting the Top row, Left column, Bottom row, or Right column check box.
Note A name created by using this procedure refers only to the cells that
contain values and does not include the existing row and column labels.

.......................................

Handy for returning a value from row and column intersection, like a mileage
chart or similar.

See this google thread for a practical use.

http://snipr.com/1n8rd


Gord Dibben MS Excel MVP


On Fri, 8 Jun 2007 18:55:03 -0700, zhj23
wrote:

Could someone please explain the difference between Name/Define and
Name/Create under the Insert Menu?

Many thanks.

zhj23

Thank you very much for the detailed explanation. I shall explore it further.

zhj23

"Gord Dibben" wrote:

NameDefine is used to define a range and give it a name like MyRange

NameCreate is to used to re-define existing row and column labels to names.

From Help.............................

Convert existing row and column labels to names

Select the range you want to name, including the row or column labels.
On the Insert menu, point to Name, and then click Create.
In the Create names in box, designate the location that contains the labels by
selecting the Top row, Left column, Bottom row, or Right column check box.
Note A name created by using this procedure refers only to the cells that
contain values and does not include the existing row and column labels.

.......................................

Handy for returning a value from row and column intersection, like a mileage
chart or similar.

See this google thread for a practical use.

http://snipr.com/1n8rd


Gord Dibben MS Excel MVP


On Fri, 8 Jun 2007 18:55:03 -0700, zhj23
wrote:

Could someone please explain the difference between Name/Define and
Name/Create under the Insert Menu?

Many thanks.

zhj23