| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
List deleting or changing
I have a list of data that was given a name to an area of data though I've
added more data (rows) and the list doesn't work with the new data added and reverts back to the original named list regardless of row additions anywhere. How do I change the range of data named to cover the extra data/rows added? i can't seem to find the right information about this. Thank you. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
List deleting or changing
Try Debra's page at:
http://www.contextures.com/xlNames01.html#Dynamic Create a Dynamic Range -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Asiageek" wrote: I have a list of data that was given a name to an area of data though I've added more data (rows) and the list doesn't work with the new data added and reverts back to the original named list regardless of row additions anywhere. How do I change the range of data named to cover the extra data/rows added? i can't seem to find the right information about this. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting a drop-down list | Excel Discussion (Misc queries) | |||
| Deleting or 'turning off' a list | Excel Discussion (Misc queries) | |||
| Changing named Validation list to Dynamic list. | Excel Discussion (Misc queries) | |||
| Deleting data in a list | Excel Discussion (Misc queries) | |||
| Deleting or changing a range name | Excel Discussion (Misc queries) | |||
Linear Mode
