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
    SS-2010.07.28-16.15.10
  3. In the Edit Hyperlink dialog box, click on “Place in This Document”
    SS-2010.07.28-16.16.36
  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.

Advertisements
  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: