Jumping to a name range location in excel 2003

I tried pasting the name range in the goto box (F5), but it did not jump to the cell reference.  Is there a way to do this?
Thanks,
JP
easycapitalAsked:
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.

rspahitzCommented:
Paste the name in the Name box (where you usually see the cell reference, like A1 of G7, above and to the left of Column A.
0
StephenJRCommented:
When you press F5, doesn't the name appear in the top box?
0
dlmilleCommented:
There certainly is.  However, potentially either you made a type-o or you specified a name range which is out of scope.  Go to the Name Manager (see Formula Ribbon, under Names), and look at the named range you're trying to use.  Is its scope "Workbook", or the current Sheet name that you're on?  If it is scoped to a specific sheet, you have to be on that sheet to use the named range.

Alternatively, if it is locally (sheet) scoped, you can put the following into the GOTO box:  Sheet!NameRange

Hope this helps!

Dave
0
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

rspahitzCommented:
In 2003, the Name Manager is under the Insert menu, where you can Define and see the options.
In 2003, think there's only one scope: global.

Also, in the Name box, click the dropdown next to it for a list of choices, and select the choice to go there.
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
billmercerCommented:
You don't specify what does happen when you paste the name into the goto dialog. Does it give an error?

If you copied the name from a cell, make sure the value you copied doesn't include any quotes or something like that.

In the small box just above the upper left cell it shows the currently selected cell or range.
If you have created a range name, then clicking the little down arrow to the right of this box will give you a drop-down list of ranges. Does the value you're pasting appear on that list?

What happens if you paste the value into that box and hit enter?
0
dlmilleCommented:
Ahhh... Correct Excel 2003.  So, appears to be a type-o.  Yes, agreed - there's a list in both Excel 2003 and 2007 of the named ranges that you can go to.  Double clicking on the name in the listbox should work.  Is that working?

Dave
0
easycapitalAuthor Commented:
All very good info.  Yes in 2003, I believe it is not called a range - I am more used to using 2007.

Thanks,
JP
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.