When managing conditional formatting … MENU Format>Conditional>Manage - the facility permits the user to continually select the “next target” for management, so it’s possible to manage any number of conditions in one session.
However, when managing named ranges … MENU Sheet>Named ranges and expressions>Manage - the moment a change is committed, the facility exits and forces the user to start all over again to manage more items.
Is there a reason why the two “sessions” do not permit the same interaction?
Is it worthy of either a bug or enhancement report?
IMO the managing named ranges would be greatly improved by the “next target” procedure.
Hello! Probably, the developers thought (and I agree with them) that changes to named ranges are rare compared to adding new ones, and for this reason they did not make a separate button. But, of course, you can make your suggestions.
Yeah, I suppose that makes sense.
I only noticed it because I managed to create about a dozen ranges that went to the last row. I don’t really know whether that has a performance impact but I considered it prudent to limit them to the probable maximum (+ a margin of error).
Perhaps you have a recommendation on that - is it wasteful/detrimental to extend the label to the last row?
It depends on what you are going to do with these ranges. If used in formulas, it is better to limit it to some reasonable limits, for example, A1:A1000
. Or later expand the used ranges by inserting rows (columns) inside the range - the named ranges will expand automatically.
That’s the dichotomy, I was assessing the difference between actual ranges viz A1:A3572 named in the formulae where A3572 is automatically expanded by the action of inserting cells within the range and, replacing the actual ranges with labels. Some of my sheets have clusters of formulae which if replicated as groups perform as expected but don’t play quite so well if I just drag them down to fill another 100 rows - the topic of my earlier post How to insert a variable number of columns or rows
At least, the learning curve is enjoyable.