naming cells using insert > name> define

[Guest]

Topic: Naming a cell or a range of cells using Insert > Name (Excel 2003)

I can see that you can define a name for a cell or range of cells using
Insert > Name > Define.

I can see that you can define a range using a row label by using Insert >
Name > Create.

I can see that you can put a named cell(s) into a function using Insert >
Name > Paste.

I can see that you can update a spreadsheet with newly defined named cells
using Insert > Name > Apply.

But I can not work out what Insert > Name > Label does.

I have search office help and Microsoft office online, I have looked a two
level 3 Excel books and I can not find an explanation.

Can you help?

 

[Gord Dibben]

I found this item in Excel Help when I typed in "label ranges"

About labels and names in formulas

Click on it and read. Maybe give you some insight.


Gord Dibben MS Excel MVP

On Fri, 30 Mar 2007 12:30:00 -0700, Educating Rita <Educating

 

[Guest]

If you have a table with column headings and row headings you can define the
headings using Insert > Name > Label. If you then refer to the cell in a
formula you see the column and row headings rather than the cell reference.
You do need to turn this on using tools>options>calculation tab>accept labels
in formulas.

Hope this helps
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)