View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erika Erika is offline
external usenet poster
 
Posts: 120
Default List and Data Validation

What we'd like to do is be able to add text to whatever drop down value we
choose to drop into a cell in those columns. Right now, once you select a
drop down value and then try to add to it, Excel gets says "a user has
restricted values in this cell." If we can select a drop down value ... and
then modify it a little, we can remove columns C and F from our spreadsheet.