Excel List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Archer - 01 Mar 2008 14:49 GMT

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.

Signature

Thanks,
Mike

Reply to this Message

Pete_UK - 01 Mar 2008 14:54 GMT

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

Is this what you meant?

Pete

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

Reply to this Message

Debra Dalgleish - 01 Mar 2008 15:03 GMT

Select a cell in the list
Choose Data>List>Convert to Range
Click Yes to confirm

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

Signature

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

Reply to this Message

Mike Archer - 01 Mar 2008 15:59 GMT

Thats what I needed. Thank you very much.

Signature

Thanks,
Mike

> Select a cell in the list
> Choose Data>List>Convert to Range
[quoted text clipped - 3 lines]
> > 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.

Reply to this Message