Convert an Excel list to a Range

  • Thread starter Thread starter ryguy7272
  • Start date Start date
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--
 
Is the activecell within the List range?

Is the worksheet protection enabled?


Gord Dibben MS Excel MVP
 
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

Similar Threads

Excel Limit to Named Ranges 1
Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
extend the range of cells for a drop down list 8
Excel Lists 4
Function in Excel to count and list number of entries of text valuesin a row. 2
Create a drop-down list from a range of cells 2

Back
Top