Excel Labs -Advance formula editor

Copper Contributor

Have not used this new feature very much, it was on my system then it was gone for a long time, just now figured out how to get it back.  I'm trying to make some dynamic named ranges, using offset and counta in the formula. Its nice to edit long formulas in this editor.

 

My problem is, when you make a named range, in excel you have the option to limit the scope of the named range to a worksheet, instead of a work book. WHERE is this option in EL-Adv From Editor?  It's probably something simple but i'm missing it.  Thanks.!

2 Replies