LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
DB DB is offline
external usenet poster
 
Posts: 46
Default How to Update drop-down list?

OK, I've done this before but I can't update a drop-down list. If I click
all the items in the drop down list, the name shows in the source box. I
want to add more items to the list. I type them in below, and then I select
the old ones plus the new ones, and I type in the drop-down list name, but
then it just selects the old items. How can I add new items?

Also, how can I delete drop down lists I am not using anymore? I don't see
any sort of drop-down list manager or anything...?

Thanks.



 
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
Drop down list Update vivi Excel Discussion (Misc queries) 2 January 8th 09 01:08 AM
Using Drop-Downs (ValidationList) to update a budget msnyc07 Excel Discussion (Misc queries) 1 December 4th 08 05:10 PM
Update Formula's based on drop down list value Steven Taylor Excel Worksheet Functions 3 July 15th 07 01:48 AM
Text to Columns from drop down list update Kurgan Excel Discussion (Misc queries) 0 June 21st 05 12:14 PM
Update Excel Data List for Drop Down use LynnS Excel Discussion (Misc queries) 2 June 10th 05 11:35 PM


All times are GMT +1. The time now is 04:10 PM.

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

About Us

"It's about Microsoft Excel"