[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Excel 2007

I label a cells and use them cell in a worksheet.  Is there a way to find that named cell from the drop down list.  In other words, if I look at a cell that has a calculation in it that uses a named cell and I want to find that named cell, how do I find it, it could even be on another worksheet.  Help please
0
akbiro
Asked:
akbiro
  • 5
  • 4
  • 3
  • +1
3 Solutions
 
kgerbChief EngineerCommented:
It sounds like you're looking for the Trace Precedents button.  Select your cell then, on the Formulas tab in the formula Auditing group click the Trace Precedents button.

Kyle
0
 
ScriptAddictCommented:
There is a box to the left of the formula line, if you type the name in there you can jump to that named range.  Alternatively you can press F2 and see it highlighted by color.  
0
 
ScriptAddictCommented:
You can find a list of all named ranges on the formula's ribbon using Define name ->dropdown to apply names

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
akbiroAuthor Commented:
Not sure I follow.  Look at my snapshot.  In cell J4 you see the formula is -I4*GF1.  How do I find the cell named GF1  I think it is on another page

http://screencast.com/t/EBGEXepPrwKw
0
 
kgerbChief EngineerCommented:
Open the name manager (formulas tab, defined names button).  That will tell you the location of all the named ranges in the workbook.

Kyle
0
 
ScriptAddictCommented:
See where your screenshot says J4 to the left of the formula?  copy paste GF1_ into that box.  It'll jump right to it.
0
 
kgerbChief EngineerCommented:
Sorry, (formulas tab, Name Manager button in Defined Names group) :)
0
 
Saqib Husain, SyedEngineerCommented:
Press F5
Select the defined name
Ok
0
 
ScriptAddictCommented:
Look at where the hand is on this assuming it works ok.  

ScriptAddict-512268.flv
0
 
kgerbChief EngineerCommented:
@ScriptAddict,
Thanks for crashing my browser :-) j/k.  Not sure why but my computer didn't like your video.  BTW, welcome to EE!

Kyle
0
 
akbiroAuthor Commented:
I still don't get it.  My formula is =I4*GF1.  I can not find what I named GF1.  I should just be able to look at the drop down box next to the formula box, scroll down to GF1 and click on it or something and it would find it for me.  Thanks everyone for being patient with me...but I still don't get it.
0
 
kgerbChief EngineerCommented:
Ok, first of all, just to make sure, are you sure GF1 is a named range and not a reference to column "GF" row "1"?  Next, when you look in the name manager do you find the name you're looking for?

If you don't find it in the name manager then it doesn't exist.

kyle
0
 
Saqib Husain, SyedEngineerCommented:
press f5
type gf1
press ok
0
 
akbiroAuthor Commented:
thx
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now