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?

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
wrote:

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?

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 toolsoptionscalculation tabaccept 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)


"Educating Rita" wrote:

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?