I often want to change what cell range a Name refers to, and want to know quickest way to do so.
Currently, I open the Name Manager (which i can do w/ Alt+3, b/c i put it on the Quick Access Toolbar), but my file has several hundred names and scrolling through to find what I want to change is tedious.
It's simple enough to CREATE new named ranges (using the "Name Box" field to the left of the main Formula Bar), but are there any shortcuts to change a Name reference I've already set up? Even just opening the Name Manager with the Name I want already selected would be a huge help. Is there some shortcut you Named Range power-users use?
Currently, I open the Name Manager (which i can do w/ Alt+3, b/c i put it on the Quick Access Toolbar), but my file has several hundred names and scrolling through to find what I want to change is tedious.
It's simple enough to CREATE new named ranges (using the "Name Box" field to the left of the main Formula Bar), but are there any shortcuts to change a Name reference I've already set up? Even just opening the Name Manager with the Name I want already selected would be a huge help. Is there some shortcut you Named Range power-users use?
Last edited: