Convert an Excel list to a Range

R

ryguy7272

I don't have a whole lot of experience working with the List tool in Excel.
I've only created a few Lists before, but I have never had to turn off a
List. Today I do need to terminate a List; I did a little research on this
topic:
http://office.microsoft.com/en-us/excel/HP010317181033.aspx

it seems easy to convert the List to a Range, but under the List > Convert
to Range is greyed-out in my Excel sheet. How do I turn off the List
feature???

Thanks,
Ryan--
 
G

Gord Dibben

Is the activecell within the List range?

Is the worksheet protection enabled?


Gord Dibben MS Excel MVP
 
R

ryguy7272

Yes, the activecell within the List range and no Protection is not applied.
It seems like it should be a simple procedure to disable the List tool...but
I just can't do it!!

Any other thoughts on this matter?

Thanks,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top