SOLVED

Range Names

%3CLINGO-SUB%20id%3D%22lingo-sub-1566115%22%20slang%3D%22en-US%22%3ERange%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566115%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20upper%20left%20corner%20includes%20a%20box%20for%20range%20names%3B%20how%20do%20you%20delete%20a%20range%20to%20add%20another%3F%20Four%20or%20five%20seem%20to%20max%20out%20the%20use%20of%20the%20feature%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1566115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566143%22%20slang%3D%22en-US%22%3ERe%3A%20Range%20Names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566143%22%20slang%3D%22en-US%22%3ETo%20delete%20names%20ranges%2C%20go%20to%20Formulas%20tab%20and%20select%20Name%20Manager..%20Then%2C%20locate%20the%20named%20range%20by%20selecting%20it%20and%20click%20on%20Delete%3C%2FLINGO-BODY%3E
New Contributor

The upper left corner includes a box for range names; how do you delete a range to add another? Four or five seem to max out the use of the feature

4 Replies
Best Response confirmed by Frank_70643466 (New Contributor)
Solution
To delete names ranges, go to Formulas tab and select Name Manager.. Then, locate the named range by selecting it and click on Delete
Thanks! It works!
You don't have to. I have just created an array with 300 named rows and 2 named columns. All 302 are visible with a scroll bar. Formula / Name Manger gives a more detailed view.
You're welcome