Removing List from Cells

  • Thread starter undrline via OfficeKB.com
  • Start date
U

undrline via OfficeKB.com

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.
 
D

Dave Peterson

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.
 
U

undrline via OfficeKB.com

Now I really feel dumb. Thanks.

Dave said:
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.
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
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...
 
Top