Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mass Creation of Named Ranges? | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |