easy way to find location of the named cells?

D

Dave Peterson

Maybe you'd be better off using: Insert|Name|Define and looking at that list.

or...

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much easier.
 
G

Guest

Maybe this..........

="Column "&COLUMN(somecell)&", Row "&ROW(somecell)


Vaya con Dios,
Chuck, CABGx3
 
G

Greg

Is there an easy way to find the location of a named cell?
If I am looking for a cell named SOMECELL.
I cannot just select it in the "Name Box" on the formula bar. Because it
will change the current cell to that name.

is there a good way to find the location? or get to the location?

thanks
 
G

Guest

F5 > select SomeCell > ok..........will take the cursor there.........

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top