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.
by Allen Wyatt
(last updated August 2, 2017)
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:
Figure 1. The Insert Hyperlink dialog box.
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.
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!
Word and Excel are both integral parts of Microsoft's Office suite of applications. As such, Word allows you to embed ...Discover More
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
Word makes it easy to establish links between documents. Here's how to change and manage those links easily.Discover More
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
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.