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

Hyperlinking to a Specific Excel Worksheet

Written by Allen Wyatt (last updated June 11, 2021)
This tip applies to Word 2007 and 2010


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 Hyperlink tool on the Insert tab of the ribbon or press Ctrl+K. 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 Ctrl+click 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.xlsx, 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 (9805) applies to Microsoft Word 2007 and 2010. You can find a version of this tip for the older menu interface of Word 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. ...


Deleting Blank Rows

Got some pesky blank rows in your data that you want to get rid of? This tip provides a wide variety of methods you can ...

Discover More

Selecting Tabs in Dialog Boxes

Dialog boxes normally present information in a series of tabs. If you want to move from tab to tab without taking your ...

Discover More

Searching for Floating Graphics

Graphics can be added to a document so that they are either inline with the text or floating over the text. You can use ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (ribbon)

Changing Many Link Locations

Word makes it easy to establish links between documents. If you need to change the locations for a lot of links at once, ...

Discover More

Creating Documents that Don't Use Embedded Fonts

Creating a PDF file from a Word document is easier than it used to be. Getting that PDF to contain exactly what you want ...

Discover More

Linking to Slides in PowerPoint

If you are preparing a document that references a presentation you created in PowerPoint, you may want to reference in ...

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 one more than 0?

2022-08-31 10:14:18


@Steve's comment sorted this for me. Cheers mate.

2022-05-11 03:56:08


This does not work :

But this does work :

2019-11-05 10:10:38


This doesn't work in Office 365 (web).

2019-07-15 10:49:04



It will work in Offcie 2016 if you include a reference to a cell on the worksheet you are trying to link to. See Jesus's comment below.

2019-07-01 13:15:02


"Hyperlinking to a Specific Excel Worksheet"
A bit of a misnomer. Links to a Workbook not a Worksheet.
Below comments address this.

2019-06-30 13:12:05

James Crain

This does not work for Office 2016. The message is "Reference isn't valid." I have experimented with it & cannot get this to work. Microsoft has had a habit of changing things that work. Bummer!! Nothing on YouTube. Nothing on Microsoft. BTW - this is a great site!!

2017-04-03 11:40:17


THANK YOU STEVE....Will this Hyperlink process work Across the Office Family of Products? For example inserting a Hyperlink in Access to an associated Word File. Of course the follow on to this question is the capability for that Hyperlink in Access 2013 and 2016.
I am trying to create a Word Document for each record in Access.

2017-01-04 05:46:17

Alex Bayman

Thank you Steve for you comment (Nov '14). This sorted out my problems with this tip. Using Office 2013 don't use apostrophes and provide a specific cell reference, eg:
... Triage Plan Reformatted.xlsx#Policies!A1

2016-09-29 03:04:09

Kishore V

Works Well when you try to link to a specific cell of a sheet, linking to a sheet as such is returning an error. Comment from 'Jesus' saved me! :D ;)

2016-08-16 03:24:46


Thanks so much.
you are special.

I am using 2013

2016-05-18 10:19:04

Dan Mota

This does not work at all

2016-01-28 15:56:23


Greetings All,

I tried the above hyperlink on both file types .xlsx and .xls and they both return the message "Reference is not valid". Here is my link...
... 12-12_12_138.xlsx#'Sheet2'

I am using Office Home and Student 2010 running on Windows 7 Home Premium.

Thank you very much

2015-03-11 09:14:27


It does work for Excel 2007, all you need is a complete reference to the worksheet- so you also have to specify the Cell.

2015-02-18 16:26:02


Excel 2010 requires a reference to a specific cell or range with a worksheet, so this does not work in creating a hyperlink to a chart.

2015-02-09 01:38:00


It's doesn't work in excel 2007
easily; you can choice the specific worksheet by clicking on Bookmark button, select the sheet name and click OK.

2015-02-06 08:28:57


Unfortunately this feature does not work for opening remote xls-files whose URLs start with "http://". Any advise?

2014-11-02 18:27:40


Your example is incomplete. I eventually worked it out: ....xlsx#DeptTotals!A1
You need a cell reference at the end or it errors out. Using Word 2013.

2012-06-11 20:02:36


The information about linking to Excel workbook specific tab is not correct. It may work in version 2003, but not in 2007 or Office 2010. It opens the file, but does not navigate to a specific tab or cell.

This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu 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.