View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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.