excel_stuff
Member
Hi Excel gurus,
I have a quick question and would appreciate advice.
I have a lot of named cells which I use in different formulae. Every time I want to go to the actual location of the named cell I go the Name Manager and find the named cell and then close it and then go to the location. This is all very time consuming. Is there a quick way to do this.
Ideally, what I would like is that when I see a named cell in a formula then I want to go directly to the named cell to check what it is etc.
Any help would be appreciated
Shehzad
I have a quick question and would appreciate advice.
I have a lot of named cells which I use in different formulae. Every time I want to go to the actual location of the named cell I go the Name Manager and find the named cell and then close it and then go to the location. This is all very time consuming. Is there a quick way to do this.
Ideally, what I would like is that when I see a named cell in a formula then I want to go directly to the named cell to check what it is etc.
Any help would be appreciated
Shehzad