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

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

Now I really feel dumb. Thanks.

Dave Peterson wrote:
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
[quoted text clipped - 5 lines]
--
Message posted via http://www.officekb.com


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200703/1