#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 52
Default Excel List

hello. I created a list in a workbook to find out what it is all about. Now
I want to get rid of it. I couldn't find any guidance in the help files on
removing lists. Please help if you can.
--
Thanks,
Mike
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Excel List

Highlight all the cells in the list and press the <delete key to remove
them.

Is this what you meant?

Pete

"Mike Archer" wrote in message
...
hello. I created a list in a workbook to find out what it is all about.
Now
I want to get rid of it. I couldn't find any guidance in the help files
on
removing lists. Please help if you can.
--
Thanks,
Mike



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Excel List

Select a cell in the list
Choose DataListConvert to Range
Click Yes to confirm

Mike Archer wrote:
hello. I created a list in a workbook to find out what it is all about. Now
I want to get rid of it. I couldn't find any guidance in the help files on
removing lists. Please help if you can.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 52
Default Excel List

Thats what I needed. Thank you very much.
--
Thanks,
Mike


"Debra Dalgleish" wrote:

Select a cell in the list
Choose DataListConvert to Range
Click Yes to confirm

Mike Archer wrote:
hello. I created a list in a workbook to find out what it is all about. Now
I want to get rid of it. I couldn't find any guidance in the help files on
removing lists. Please help if you can.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to Create a List in Excel 2002; Don't see List in Data Menu? Manoj Excel Discussion (Misc queries) 2 April 7th 06 07:34 PM
base price list compute on to another price list? on excel work sh excel spread sheet Excel Discussion (Misc queries) 0 March 29th 06 06:20 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 Ed Excel Worksheet Functions 5 September 12th 05 09:48 AM
Does Excel 2002 have a List>Create List option under Data? Jesse Excel Discussion (Misc queries) 3 May 20th 05 01:52 PM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"