Hi Everyone,
I set up a drop down menu (pick from list) and now I need to add another option - how do you add to aan existing drop down without deleting what you have already entered?
Hi Everyone,
I set up a drop down menu (pick from list) and now I need to add another option - how do you add to aan existing drop down without deleting what you have already entered?
Last edited by 1Monkey; 08-15-2012 at 02:40 PM.
Extend the data validation list to include your last cell
e.g.
=$G$1:$G$8 will become =$G$1:$G$9 to include Cell G9
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks - I ended up having to go into Data Validation to add the entry - but I really appreciate your quick response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks