| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List of defined names
Hi All, Is there a way to get a list of the names, that one has defined in a worksheet, whilst entering a formula into a cell or a graph? If not is it something other people would find useful? -- coa01gsb ------------------------------------------------------------------------ coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214 View this thread: http://www.excelforum.com/showthread...hreadid=524826 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List of defined names
When you're ready to insert the range name, press the F3 function key
"coa01gsb" wrote: Hi All, Is there a way to get a list of the names, that one has defined in a worksheet, whilst entering a formula into a cell or a graph? If not is it something other people would find useful? -- coa01gsb ------------------------------------------------------------------------ coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214 View this thread: http://www.excelforum.com/showthread...hreadid=524826 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List of defined names
You obviously understood the OP's question better than I did!
-- Kind regards, Niek Otten "Duke Carey" wrote in message ... When you're ready to insert the range name, press the F3 function key "coa01gsb" wrote: Hi All, Is there a way to get a list of the names, that one has defined in a worksheet, whilst entering a formula into a cell or a graph? If not is it something other people would find useful? -- coa01gsb ------------------------------------------------------------------------ coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214 View this thread: http://www.excelforum.com/showthread...hreadid=524826 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List of defined names
Thanks, That F3 bit is going to save me a load of hassle with functions, shame it doesn't work for graphs -- coa01gsb ------------------------------------------------------------------------ coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214 View this thread: http://www.excelforum.com/showthread...hreadid=524826 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List of defined names
Not easily with a formula.
On an empty sheet, choose InsertNamePastePaste List -- Kind regards, Niek Otten "coa01gsb" wrote in message ... Hi All, Is there a way to get a list of the names, that one has defined in a worksheet, whilst entering a formula into a cell or a graph? If not is it something other people would find useful? -- coa01gsb ------------------------------------------------------------------------ coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214 View this thread: http://www.excelforum.com/showthread...hreadid=524826 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a chart from a list of names? | Charts and Charting in Excel | |||
| How do I create/filter a list of names without duplications | Excel Discussion (Misc queries) | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| How do I print a list of worksheet tab names in a workbook | Excel Worksheet Functions | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
