Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Hyperlinking to a Specific Excel Worksheet.

Hyperlinking to a Specific Excel Worksheet

Written by Allen Wyatt (last updated December 29, 2018)
This tip applies to Word 97, 2000, 2002, and 2003


Word allows you to easily add links to other Microsoft Word documents, such as those created by Excel. These links can be created in a number of ways, such as by using the Paste Special dialog box and choosing the Paste As Link option.

Excel also allows you to create hyperlinks to other Office documents. In many ways these hyperlinks are similar to regular links, but they have the express purpose of opening the target document and displaying exactly the information you want. For example, to create a hyperlink to an Excel worksheet, you would follow these steps:

  1. In your Word document, position the insertion point at the location where you want the hyperlink to appear.
  2. Click the Insert Hyperlink tool on the toolbar, or choose Hyperlink from the Insert menu. Word displays the Insert Hyperlink dialog box.
  3. Make sure Existing File or Web Page is selected. (See Figure 1.)
  4. Figure 1. The Insert Hyperlink dialog box.

  5. Use the tools in the middle of the dialog box to navigate and select the Excel workbook you want linked to. The address of that file should appear in the Address box.
  6. Change the Text to Display box so it contains whatever you want in the document; this is the text that will be clickable as the hyperlink.
  7. Click OK.

Your hyperlink is now created, and you can click (or Ctrl+click in some versions of Word) to access the target of the hyperlink. When you do this, the Excel workbook you specified in step 4 is opened, and the first worksheet in the workbook is displayed.

If you want to display a specific worksheet, all you need to do is modify what appears in the Address box as you are setting up the hyperlink. For instance, if you, in step 4, navigate to a workbook named Budget2010.xls, the Address bar might contain something like this:


To open a specific worksheet, simply tack the worksheet's name onto the end of the address, prefaced by a pound sign as shown here:


Note that the worksheet name is surrounded by apostrophes and separated from the workbook name by a pound sign. If you want to make sure that a specific cell is displayed on the target worksheet, you can further refine the address in this manner:


If you use named ranges in your workbook, you can use the name of a range you want displayed instead of using a sheet and cell name:


Note that when you use a named range, you don't need to surround it by apostrophes as is done with worksheet names. Excel is opened and the range is displayed. If the range doesn't exist, the desired workbook is still opened, but Excel informs you that the range name is invalid.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (305) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Hyperlinking to a Specific Excel Worksheet.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...


Printing a Font List

Getting a list of fonts available in a document is not something you can easily do in Word. That is, unless you put the ...

Discover More

Correctly Repeated Words

There are times when you need to repeat a word in a document, but doing so triggers an "error reaction" from Word's ...

Discover More

Understanding Font Styles

Fonts, by default, come with one or more styles that define variations of how that font is displayed in your document. ...

Discover More

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

More WordTips (menu)

Word Link to Create a New Excel Workbook

It's easy to create and include links in your documents to other sources, in and out of Word. There are some limitations ...

Discover More

Embedding an Excel Chart in a Word Document

Word and Excel usually work pretty well together. This means that you can easily paste charts from Excel into your Word ...

Discover More

Unlinking an Excel Chart Automatically

When Excel charts are linked in a Word document, they update every time the document is opened. Here's how to unlink the ...

Discover More

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is three more than 1?

2021-10-07 10:44:50


I have followed your advice in creating a hyperlink to a specific worksheet. When I click on the hyperlink in Word, it takes me to the correct Excel spreadsheet but not to the specific worksheet and it give me an error "Reference isn't valid."

2021-03-27 07:20:09


Hello, thank you for this articel. I'm trying to send email from Excel via VBA with hyperlink to this workbook, with specific sheet and cell. It is working but if I klik na link in received email, it doesn't open file but try it download. Original file location is in sharepoint. How can I force it to open file instead of download? If I use link without sheet and cell than file is opened.

this creat link which open file

this creat link which download file
ActiveWorkbook.FullName & "#'" & ActiveSheet.Name & "'!" & Selection.Address

thank you for help

2019-05-17 12:18:53

Rebecca S Russell

I keep getting an "invalid reference" error when I try this. Office 2016.

This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.


FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.