Quick way to go to named cells

[excel_stuff]

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

 

[NARAYANK991]

Hi ,

Pressing F5 , or pressing the combination keys CTRL G , should bring up the Go To dialog box , in which named ranges are listed first , at the top.

Selecting any named range and pressing OK takes you to the named range.

Another way is to enter the name of the named range in the Name Box ; entering the name and pressing the ENTER key takes you to the named range.

Narayan

 

[ANKUSHRS1]

if you are doing same excel every day then i have on approach you can use.
1.select a named cell and press ctrl+k. you will get hyperlink window.
2. Select Place in this Document option availabe left side.
3. Select Defined name which you want to hyperlink to this cell.

now you can access this hyperlinked range with single click..

 

[excel_stuff]

Thank you both. This is very helpful and will save me a lot of time.

Many thanks!