Hyperlinking to a Specific Excel Worksheet
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.
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:
- In your Word document, position the insertion point at the location where you want the hyperlink to appear.
- Click the Insert Hyperlink tool on the toolbar, or choose Hyperlink from the Insert menu. Word displays the Insert Hyperlink dialog box.
- Make sure Existing File or Web Page is selected. (See Figure 1.)
Figure 1. The Insert Hyperlink dialog box.
- 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.
- 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.
- 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.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Leave your own comment:
Comments for this tip:
Bill 21 Oct 2016, 13:38
I want a user to enter a key field on a Word document, and have Word go to a spreadsheet where the key field is a unique entry in a column, and bring other columns data from that row back to populate fields in the Word document. Is this possible?
For example, enter a SSN in a field in a Word document, and bring back the name and address of that SSN from an Excel spreadsheet, and populate fields on the Word document.
david 24 Aug 2016, 11:17
can you please advise when you want to open a .xlsx file when using the formula =HYPERLINK(E18,"Open file")
and also, when a file name contains the character #
EricB 09 Dec 2015, 16:02
Update - funny how you forget stuff and then you google to find that you have already commented on this :-/. So I tried to follow my own previous advice and realized I omitted something that makes this work. Don't include the single quotes and add the cell reference. Hope that helps clarify.
sameer 06 Sep 2015, 02:41
nice artical very usefull. thank you so much
Jay Jay 01 Sep 2015, 05:17
I also tried the methods specified above and unfortunately it did not work for me. The excel workbook opens on the the last saved worksheet.
Does anyone have a solution?
Mahesh G H 29 Aug 2015, 02:03
I have set of datas in excel sheet to which i want to insert hyperlink for only part of the data.
Can u help me sir.
ssibsm 15 Jul 2015, 07:29
ok..I have a basic knowledge about excel and am trying to learn new things…need some help with this..
Example:I have made a Time sheet in excel for John..as John is not tech with IT….in this time sheet I have added details,login,logout,formulas for calculating the total hours etc…so when John receives it he just have to put the login and logout timings and the remaining is calculated automatically…
so here is my question,
1)can i email this active workbook as a body of the email(Not as attachment) to John??
2)And when John receives the email he should be able to fill the sheets with timings in the active worksheet in the email itself and forward me back the same email.(No need to download,fill,attachment and send back headache for John)
3)which mail supports this….I use outlook 2007…
so I was just wondering is there any thing like this and Detailed Answer is much appreciated…Thanks in advance
Jeetesh 12 Jun 2015, 10:27
I have 10 hyperlinks created in a single excel sheet. I want to open all the 10 hypelink by a single click. How to do that ?
Kindly assist me.
Thank You in advance.
khas 18 Mar 2015, 15:11
i try best but i am not successful
<a href="http://khas.khasstores.com/index.php?id_category=106&controller=category&id_lang=1">Flour Rugs</a>
John Polasek 18 Sep 2014, 10:13
The responses show that there is an awful lot of trouble getting the address correct in creating a hyperlink.
If you just want to jump to a spreadsheet from Word, try this:
Open the spreadsheet, select and copy text \Ctl C, (which will be the title of your link). Open the Word document and (anywhere) click \Alt Edit Hyperlink. The text appears in blue and it is your clickable hyperlink.
Return to Word with Alt Left Arrow.
Zaini 17 Sep 2014, 20:16
Thank you so much Eric B, do not use the single quote, it works fine.
Aman 10 Jul 2014, 22:54
hi i have this link which i open in the url,i try using your method,but its not working...is there anything i did wrong?
R S 15 Jan 2014, 02:48
Works great, problem solved, just gonna put !A1 on the end of the hyperlink if you just want to open the sheet
John Polasek 03 Aug 2013, 15:48
I should add that there is a way (not easy to find) of jumping back from the spreadsheet to the original document: Alt leftarrow.
John Polasek 03 Aug 2013, 15:36
This is a very simple way to get a hyperlink to a spreadsheet cell (Word 97):
Copy with Ctl C any spreadsheet cell that has a significant TEXT.
In the other document, click the location for the hyperlink TEXT, and press Alt Edit Hyperlink (AEH). The TEXT appears in blue and it is the hyperlink that will jump you back to that cell.
d 02 Aug 2013, 14:44
You cannot have spaces in the name. Use underscores for the spaces
Jason 10 Jun 2013, 13:45
Max and Molly: Per Narcis' comment, this tip will not work unless you put a cell reference at the end.
For example, the following will not work:
You have to add a cell reference:
(Note that the cell reference doesn't have to be A1; it can be any cell in the worksheet.)
The author should update the tip to reflect this.
Narcis 24 Oct 2012, 06:38
try adding !A1 after workbook name
e.g.: ITA%20Assignment%20Section%20A%20Final.xlsx#'Flower Stalks Gallery'!A1
Eric B 17 Sep 2012, 16:59
I tried this technique. It didn't work until I tried it without the single quote marks. When I omitted the single quote marks, it works perfectly.
Max Ujhazy 09 Sep 2012, 10:30
I also tried it the way you said above, end result being:
ITA%20Assignment%20Section%20A%20Final.xlsx#'Flower Stalks Gallery'
and it says reference not valid, when it is exactly as said above.
Molly F 28 Jun 2012, 13:02
I tried linking to a specific worksheet using the #'Due Dates' example above, but it didn't work. Does it have to be one word? Does it not recognize spaces?