Name --- Define and Create

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Many thanks.

zhj23
 
Name>Define is used to define a range and give it a name like MyRange

Name>Create 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
 
Back
Top