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.

  1. #1 by Casino Baccarat Hp Android on April 5, 2018 - 2:31 pm

    Great looking internet site. Assume you did a bunch of your very own html coding.|

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 )

Facebook photo

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

Connecting to %s

%d bloggers like this: