Mike H.. Active Member Sep 4, 2014 #2 J G said: Naming a range of cells is super easy. How do I delete those names? Click to expand... Hi, Formulas tab | Defined names group | Name manager and select and delete your names that you want to get rid of.
J G said: Naming a range of cells is super easy. How do I delete those names? Click to expand... Hi, Formulas tab | Defined names group | Name manager and select and delete your names that you want to get rid of.
Luke M Excel Ninja Staff member Sep 4, 2014 #3 Under Formulas Ribbon, click on Name Manager. Find the name you want, and hit delete.
J J G Member Sep 4, 2014 #4 Thank you! Somehow I have a single selection of cells with the same name in my list two times. The value of one of these names in the Name Manager is #REF! which excel is of course picking up when I try to use it in my formula.
Thank you! Somehow I have a single selection of cells with the same name in my list two times. The value of one of these names in the Name Manager is #REF! which excel is of course picking up when I try to use it in my formula.
