Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
M. Watt
 
Posts: n/a
Default 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   Report Post  
Alan
 
Posts: n/a
Default

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   Report Post  
M. Watt
 
Posts: n/a
Default


Excellent, Thank you.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation lists - entering value not in list rgarber50 Excel Discussion (Misc queries) 3 July 19th 05 08:35 PM
Making pick list conditional on selection from previous pick list Stewart Excel Discussion (Misc queries) 1 June 27th 05 11:30 AM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Refresh a Validation List? jhollin1138 Excel Discussion (Misc queries) 3 February 17th 05 05:48 PM
edit a drop down list paulp Excel Discussion (Misc queries) 1 December 22nd 04 03:20 PM


All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"