Excel: How to add a hyperlink to another location in the same workbook

It is fairly common knowledge that we can create hyperlinks (e.g., to a website or email address) in MS Office programs. I just recently discovered that you can create a hyperlink to another location in the same Excel workbook. I challenge you to come up with a creative application for this trick.

Here’s how:

1. Click on the cell that contains the text that needs to be a hyperlink
2. On the ribbon, go to the Insert tab and click on Hyperlink
   
3. In the Edit Hyperlink dialog box, click on “Place in This Document”
   
4. Select a worksheet under “Cell Reference” and type a cell reference in the text entry above.
5. Click OK

NOTE: This will work in Word as well, but you must have headings and/or bookmarks to serve as anchors for the hyperlinks.