Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I edit a List?
I have created several lists, and discovered that now that they are defined I
can't seem to edit them. I would like to add cells, to the list as more data is collected or simply change which cells are selected. Any ideas? |
#2
|
|||
|
|||
Go on to 'Insert' on the toolbar at the top, click 'Names', click 'Define',
select your named range and edit as appropriate, click 'OK' Regards, Alan. "M. Watt" <M. wrote in message ... I have created several lists, and discovered that now that they are defined I can't seem to edit them. I would like to add cells, to the list as more data is collected or simply change which cells are selected. Any ideas? |
#3
|
|||
|
|||
Excellent, Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation lists - entering value not in list | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
edit a drop down list | Excel Discussion (Misc queries) |