Named Ranges & Natural Language Formuals
 

How does one use the Label command from the Insert Menu/Name when using Named
Ranges?

If I'm using Natural Language Formulas, i.e. using column headings as
arguments in my functions (without defining the column headings as names), is
there a way to determine what range of cells that name refers to, without
having to scroll back up to the top of the column?

Let's say I have the column heading "January" and underneath I have 5000
cells of every sale made in January. Below, I use, =SUM(January). I would
like to know what January in the SUM function refers to quickly.

Thanks.

Named Ranges & Natural Language Formuals
 

1) You could click on row header 2 then use Window | Freeze so you can
always see the column label.
2) I believe XL2007 will not let you use 'natural language formulas - MS has
decided this was a feature that had too many problems. The column header
name can mean a range or a single cell depending where the formula is
located and this gave rise to many errors
Most experts advise not to use this feature.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kokomojo" wrote in message
...
How does one use the Label command from the Insert Menu/Name when using
Named
Ranges?

If I'm using Natural Language Formulas, i.e. using column headings as
arguments in my functions (without defining the column headings as names),
is
there a way to determine what range of cells that name refers to, without
having to scroll back up to the top of the column?

Let's say I have the column heading "January" and underneath I have 5000
cells of every sale made in January. Below, I use, =SUM(January). I
would
like to know what January in the SUM function refers to quickly.

Thanks.

Named Ranges & Natural Language Formuals
 

I believe XL2007 will not let you use 'natural language formulas

That's right. Excel 2007 will replace formulas like =Table with something
like =D$6:D$65536 (where the Table label was in cell D5).

--
Jim
"Bernard Liengme" wrote in message
...
| 1) You could click on row header 2 then use Window | Freeze so you can
| always see the column label.
| 2) I believe XL2007 will not let you use 'natural language formulas - MS
has
| decided this was a feature that had too many problems. The column header
| name can mean a range or a single cell depending where the formula is
| located and this gave rise to many errors
| Most experts advise not to use this feature.
| --
| Bernard V Liengme
| www.stfx.ca/people/bliengme
| remove caps from email
|
| "Kokomojo" wrote in message
| ...
| How does one use the Label command from the Insert Menu/Name when using
| Named
| Ranges?
|
| If I'm using Natural Language Formulas, i.e. using column headings as
| arguments in my functions (without defining the column headings as
names),
| is
| there a way to determine what range of cells that name refers to,
without
| having to scroll back up to the top of the column?
|
| Let's say I have the column heading "January" and underneath I have 5000
| cells of every sale made in January. Below, I use, =SUM(January). I
| would
| like to know what January in the SUM function refers to quickly.
|
| Thanks.
|
|

Named Ranges & Natural Language Formuals
 

Thank you Bernard. This was most helpful. Do you know how to use the Label
option when you go to the Insert Menu and click on Name?

Thanks.

"Bernard Liengme" wrote:

1) You could click on row header 2 then use Window | Freeze so you can
always see the column label.
2) I believe XL2007 will not let you use 'natural language formulas - MS has
decided this was a feature that had too many problems. The column header
name can mean a range or a single cell depending where the formula is
located and this gave rise to many errors
Most experts advise not to use this feature.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kokomojo" wrote in message
...
How does one use the Label command from the Insert Menu/Name when using
Named
Ranges?

If I'm using Natural Language Formulas, i.e. using column headings as
arguments in my functions (without defining the column headings as names),
is
there a way to determine what range of cells that name refers to, without
having to scroll back up to the top of the column?

Let's say I have the column heading "January" and underneath I have 5000
cells of every sale made in January. Below, I use, =SUM(January). I
would
like to know what January in the SUM function refers to quickly.

Thanks.

Named Ranges & Natural Language Formuals
 

Suppose B1 has the text/label January
Select B1 down to the last item in the B column
Use Insert | Name Create; a dialog will pop up and ask if you want to use
the name at the top.
OR
Select B2:B100 (whatever)
In Name box type January and press ENTER key (last step is essential)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kokomojo" wrote in message
...
Thank you Bernard. This was most helpful. Do you know how to use the
Label
option when you go to the Insert Menu and click on Name?

Thanks.

"Bernard Liengme" wrote:

1) You could click on row header 2 then use Window | Freeze so you can
always see the column label.
2) I believe XL2007 will not let you use 'natural language formulas - MS
has
decided this was a feature that had too many problems. The column header
name can mean a range or a single cell depending where the formula is
located and this gave rise to many errors
Most experts advise not to use this feature.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kokomojo" wrote in message
...
How does one use the Label command from the Insert Menu/Name when using
Named
Ranges?

If I'm using Natural Language Formulas, i.e. using column headings as
arguments in my functions (without defining the column headings as
names),
is
there a way to determine what range of cells that name refers to,
without
having to scroll back up to the top of the column?

Let's say I have the column heading "January" and underneath I have
5000
cells of every sale made in January. Below, I use, =SUM(January). I
would
like to know what January in the SUM function refers to quickly.

Thanks.