View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Removing List from Cells

Did you use Data|Validation to create the dropdown?

If yes, then use Data|Validation and hit the "clear all" button on the bottom of
the dialog.

"undrline via OfficeKB.com" wrote:

I feel like such a noob asking this question, but how do you get rid of a
drop-down list you've created for a group of cells, particularly without
changing the data currently in the cells, or changing the "lookup" data that
the list was based on?

Thanks.

--
Message posted via http://www.officekb.com


--

Dave Peterson