Hello. WHen I press contrl G it shows me my named ranges but also a bunch of other ranges. How can I see just my named ranges to go to?
Hello. WHen I press contrl G it shows me my named ranges but also a bunch of other ranges. How can I see just my named ranges to go to?
Hi Amma another tricky thing
but this time it seems that you can have range whatever is been defined in that particular workbook. What type of other ranges it shows you? Do you have any attachment for this?
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
Alternatively you can use the Name Box (left to the formula bar) to select a Named Range. Expand the Name Box by clicking drop down triangle and it will show you all the named ranges.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks