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.
- Click on the cell that contains the text that needs to be a hyperlink
- On the ribbon, go to the Insert tab and click on Hyperlink
- In the Edit Hyperlink dialog box, click on “Place in This Document”
- Select a worksheet under “Cell Reference” and type a cell reference in the text entry above.
- 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.