Named Ranges & Natural Language Formuals

K

Kokomojo

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.
 
B

Bernard Liengme

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.
 
J

Jim Rech

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
| 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
|
| | > 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.
|
|
 
K

Kokomojo

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.
 
B

Bernard Liengme

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
 
Top