Solved I can not delete a drop-down list

Microsoft Excel 2003 (full)
February 19, 2012 at 09:10:03
Specs: Windows XP, 1.0Gb
I can not delete a drop-down list. I used Data>Data Validation>Clear All" and that deleted the list but did not remove the list's name from "Names".

Thank you.
Brian W

See More: I can not delete a drop-down list

February 19, 2012 at 12:35:34
✔ Best Answer
Unless I misunderstand what you are doing, the Names list has nothing to do with Data Validation.

A Named Range is simply a range of cells that you have Named by using one of the various ways to name a range in Excel.

You can now use that name in place of cell references in formulas, macros, and yes, even Data Validation lists.

e.g. If you give A1:A7 a name of MyCells, you can now use =SUM(MyCells) instead of =SUM(A1:A7).

Deleting a Data Validation list simply deletes the Drop Down. It doesn't know anything about any Named Ranges in your workbook, nor should it. Imagine if you had a Drop Down based on MyCells as well as formulas that referred to MyCells. If you chose to delete the Drop Down and it also deleted the name from the Names list, all of the formulas that referred to MyCells would break.

If you want to delete the Name of a Named Range, you need to use the Name Manager found on the Formulas ribbon.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 19, 2012 at 15:06:30

Thank you for your response; as usual, you are always on target.

Brian W

Report •
Related Solutions

Ask Question