| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
finding the data location of a list in my xls
Hi,
I have an xls with one of its column having a list for data validation. I want to add additional values to the list. When I go to data validation, it shows me as list and it shows me the name as TBL_PEOPLE. I thot it might be a label, but could not find it anywhere in the xls. I know it is not accessing any access tables. How can I find out where this TBL is so I can modify it? Pls help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
finding the data location of a list in my xls
try F5
"xlsstudent" skrev: Hi, I have an xls with one of its column having a list for data validation. I want to add additional values to the list. When I go to data validation, it shows me as list and it shows me the name as TBL_PEOPLE. I thot it might be a label, but could not find it anywhere in the xls. I know it is not accessing any access tables. How can I find out where this TBL is so I can modify it? Pls help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
finding the data location of a list in my xls
InsertNameDefine should show you a list of names in this workbook and the
refers to will show you the reference address. Gord Dibben MS Excel MVP On Thu, 24 May 2007 09:07:02 -0700, xlsstudent wrote: Hi, I have an xls with one of its column having a list for data validation. I want to add additional values to the list. When I go to data validation, it shows me as list and it shows me the name as TBL_PEOPLE. I thot it might be a label, but could not find it anywhere in the xls. I know it is not accessing any access tables. How can I find out where this TBL is so I can modify it? Pls help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
finding the data location of a list in my xls
Hi,
Hit the F5 key and enter the name you found (TBL_PEOPLE) and then click OK it should show you the name range. Thanks, -- Farhad Hodjat "xlsstudent" wrote: Hi, I have an xls with one of its column having a list for data validation. I want to add additional values to the list. When I go to data validation, it shows me as list and it shows me the name as TBL_PEOPLE. I thot it might be a label, but could not find it anywhere in the xls. I know it is not accessing any access tables. How can I find out where this TBL is so I can modify it? Pls help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the location of what was summed | Excel Worksheet Functions | |||
| Finding the location of MAX value in column | Excel Discussion (Misc queries) | |||
| finding data in a list | Excel Discussion (Misc queries) | |||
| Finding Location of Maximum Value in 2D Array | Excel Worksheet Functions | |||
| finding cell location | Excel Discussion (Misc queries) | |||
Hybrid Mode
