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
akbiroAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
akbiroAuthor Commented:
thx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.