Delete drop down list

's Computer Specifications

I see instructions for creating drop down lists, but not for deleting them. I
have a list that is no longer useful and would like to delete it from the
worksheet (To clarify: I am talking about removing the list from the list of
list names that appears when using the F3 key)
Thank you
--
MZ

's Computer Specifications

Select the range.

From menu Data>Validation>Select 'Any value'
OR
If you dont have data in those cells from menu Edit>Clear>All

--
Jacob

"MZ" wrote:

> I see instructions for creating drop down lists, but not for deleting them. I
> have a list that is no longer useful and would like to delete it from the
> worksheet (To clarify: I am talking about removing the list from the list of
> list names that appears when using the F3 key)
> Thank you
> --
> MZ

's Computer Specifications

Sorry, I am not sure I understood you correctly. If you are looking at
removing the names then check out the 'Delete' option from menu
Insert>Name>Define

--
Jacob

"Jacob Skaria" wrote:

> Select the range.
>
> From menu Data>Validation>Select 'Any value'
> OR
> If you dont have data in those cells from menu Edit>Clear>All
>
> --
> Jacob
>
>
> "MZ" wrote:
>
> > I see instructions for creating drop down lists, but not for deleting them. I
> > have a list that is no longer useful and would like to delete it from the
> > worksheet (To clarify: I am talking about removing the list from the list of
> > list names that appears when using the F3 key)
> > Thank you
> > --
> > MZ

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I delete a name in the 'look for' drop down list?	=?Utf-8?B?Y2hyaXM=?=	Microsoft Access	1	14th Aug 2006 05:14 PM
delete used records from drop down list?	=?Utf-8?B?UHJhc2hhbnQgVA==?=	Microsoft Excel Worksheet Functions	3	4th Aug 2006 09:56 PM
Delete drop down list	=?Utf-8?B?Y3VyaW91cw==?=	Windows XP Basics	3	1st May 2006 08:36 AM
How do I delete a drop list button	=?Utf-8?B?Q2hhbGxlbmdlZA==?=	Microsoft Excel Worksheet Functions	1	27th Sep 2005 09:05 PM
How to add and delete items from a list box or drop down box?	=?Utf-8?B?RmlmZWU=?=	Microsoft Excel Misc	2	12th Aug 2005 01:17 PM