how do I edit the content of a drop-down menu in excel?
 

how do I edit the content of a drop-down menu in excel?
 

Do you mean you want to change the selected item manually?

If yes, then in the Data Validation window, go to the Error Alert tab
and uncheck the -Show error alert after invalid data entry- checkbox.

If you want to change the list, then edit the original list.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113739

how do I edit the content of a drop-down menu in excel?
 

Do you mean the menu that you see when you right click on a cell for example ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Drop-down menus" <Drop-down wrote in message
...

how do I edit the content of a drop-down menu in excel?
 

If a Data Validation List dropdown menu, change the items in the source
range.


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 06:13:03 -0700, Drop-down menus <Drop-down
wrote: