troubleshooting Question

Use the Excel =HYPERLINK() function to jump to a cell or defined range in the SAME worksheet

Avatar of WeThotUWasAToad
WeThotUWasAToad asked on
Microsoft Excel
3 Comments1 Solution1356 ViewsLast Modified:
Hello,

When using the Excel =HYPERLINK() function, what is the proper form for jumping to a cell or defined range in the same worksheet?

The Excel Help file isn't very helpful because it only describes more distant links like going to a website URL or opening worksheets in other files. The following is the closest I can find:
=HYPERLINK("[Budget.xlsx]E56", E56)
 To jump to a different sheet in the same workbook, include the name of the sheet, followed by an exclamation point (!), in the link. In the previous example, to create a link to cell E56 on the September sheet, include September! in the link.
Here are a two examples of what I'm after:

1) Suppose you want a link in cell D4 which displays "Home" and takes you to cell A1 in the same worksheet. I know that in practice, it would be simpler to use the Hyperlink box (Ctrl+k) for this link but I'm specifically interested in seeing the form using the =HYPERLINK() function.

2) Suppose you define the range A1:A2 to be named "Origin" and instead of going to a single cell or using the cell reference A1, you want to include the named range in the =HYPERLINK() function and end up with both cells in the range being selected.

If someone could show me the formulas for these two examples, I will be off and running.

Thanks
ASKER CERTIFIED SOLUTION
Wayne Taylor (webtubbs)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros