Linking from Word to Excel
You can use Word's HYPERLINK field to link from a Word document to an Excel workbook.
Go to our all-in-one document converter. Upload and convert your Excel file into a PDF. On the next page, hit the ‘to Word’ option. And that’s it—download your Word file. How to convert an Excel file to Word using Smallpdf! Convert Excel to Word. Essentially, we are taking your Excel file, turn it into a PDF, and then to a Word processing document. Any Excel file type, including XLS and XLSX files, are accepted. With Microsoft 365 for the web (formally Office 365) you can edit and share Word, Excel, PowerPoint, and OneNote files on your devices using a web browser.
- You can create a clickable hyperlink in a Word document that will open up an Excel file. Sometimes you just need to open the Excel workbook. Sometimes you want the link to go to a specific place in the Excel workbook. This page explains how. How to create a link to an Excel workbook. In your Word document, do ctrl-F9.
- With the release of Microsoft Word 2007, Microsoft introduced the new DOCX file format based on the Open XML (Extensible Markup Language) standard. If you have Microsoft Word 2003 or earlier, you’ll need to download the free Microsoft.
To link to a specific place in the Excel file, specify an absolute address or a range name.
In a Word document, select the rows and columns of the table that you want to copy to an Excel worksheet. Make sure there aren't any extra carriage returns in the cells of the table, otherwise this may cause extra rows in Excel. To copy the selection, press CTRL+C.
You can create a clickable hyperlink in a Word document that will open up an Excel file. Sometimes you just need to open the Excel workbook. Sometimes you want the link to go to a specific place in the Excel workbook. This page explains how.
How to create a link to an Excel workbook
In your Word document, do ctrl-F9. Within the braces that word gives you, type the following:
HYPERLINK 'C:My DocumentsMyExcelFile.xls'
So it looks like
{ HYPERLINK 'C:My DocumentsMyExcelFile.xls' }
But note that you can't type the { } braces by hand. You must use ctrl-F9 and type between the braces that Word gives you.
Obviously, you need to replace the text between the quote marks with your own folder and file name. Be sure to use double back slashes (') in your path name.
When you're finished, press F9, which toggles between displaying the field codes (that you just typed) and the field result (which is the hyperlink).
When you click the link, Excel will run and will open your Excel workbook.
Click, or ctrl-click to link?
By default, you need to do ctrl-click to follow a hyperlink from a Word document.
If you don't like that, you can change it. In Word 2003 and earlier versions, do Tools > Options. On the Edit tab, un-tick 'Use CTRL + click to follow hyperlink'. In Word 2007 and Word 2010 do File > Word Options or File > Options. On the Advanced tab, in the Editing Options section, un-tick 'Use CTRL + Click to follow hyperlink'.
How to create a link to a specific place in an Excel workbook
You have two choices here. You can choose to link to an absolute address. Or, you can link to a range name.
How to link to an absolute address in an Excel workbook
In your Word document, do ctrl-F9. Within the braces that Word gives you, type so that it looks like the following:
{ HYPERLINK 'C:My DocumentsMyExcelFile.xls#MySheet!A1' }
If your sheet name contains a space, then you need to enclose it in single quote marks, like this:
{ HYPERLINK 'C:My DocumentsMyExcelFile.xls#'My Sheet'!A1' }
Alternatively, you can use the l (that's a lower-case L) switch to identify the range name:
{ HYPERLINK 'C:MyDocumentsMyExcelFile2.xls' l 'Sheet 1'!A1' }
How to link to a range name in an Excel workbook
To create a hyperlink to a Worksheet range name, use use ctrl-F9 and type so it looks like the following:
{ HYPERLINK 'C:My DocumentsMyExcelFile2.xls#'Sheet 1'!RangeName' }
To create a hyperlink to a Workbook range name, use use ctrl-F9 and type so it looks like the following:
{ HYPERLINK 'C:My DocumentsMyExcelFile3.xls#RangeName' }
However…..
Word wouldn't be Word if it were always that straight-forward! Excel gets confused if you have both a Workbook range and a Worksheet range with the same name. It seems to link to the range randomly. So, if you use range names, make sure they're all sheet-specific or all workbook-wide. Or use an absolute address.
How to add a screen tip to a hyperlink
You can use the o switch (that's a lower-case O, not a zero) to create a tooltip, like this:
{ HYPERLINK 'C:My DocumentsMyExcelFile3.xls#RangeName' o 'Click here to open MyExcelFile3' }
Related subjects
Topic: Word and Excel
Interest: For users
Version: Word 2000Word 2002Word 2003Word 2007Word 2010
Created April 2006. Last updated 21 July 2010.
Linking from Word to Excel
You can use Word's HYPERLINK field to link from a Word document to an Excel workbook.
To link to a specific place in the Excel file, specify an absolute address or a range name.
You can create a clickable hyperlink in a Word document that will open up an Excel file. Sometimes you just need to open the Excel workbook. Sometimes you want the link to go to a specific place in the Excel workbook. This page explains how.
How to create a link to an Excel workbook
In your Word document, do ctrl-F9. Within the braces that word gives you, type the following:
HYPERLINK 'C:My DocumentsMyExcelFile.xls'
So it looks like
{ HYPERLINK 'C:My DocumentsMyExcelFile.xls' }
But note that you can't type the { } braces by hand. You must use ctrl-F9 and type between the braces that Word gives you.
Obviously, you need to replace the text between the quote marks with your own folder and file name. Be sure to use double back slashes (') in your path name.
When you're finished, press F9, which toggles between displaying the field codes (that you just typed) and the field result (which is the hyperlink).
When you click the link, Excel will run and will open your Excel workbook.
Click, or ctrl-click to link?
By default, you need to do ctrl-click to follow a hyperlink from a Word document.
If you don't like that, you can change it. In Word 2003 and earlier versions, do Tools > Options. On the Edit tab, un-tick 'Use CTRL + click to follow hyperlink'. In Word 2007 and Word 2010 do File > Word Options or File > Options. On the Advanced tab, in the Editing Options section, un-tick 'Use CTRL + Click to follow hyperlink'.
How to create a link to a specific place in an Excel workbook
How Do I Convert Word To Excel
You have two choices here. You can choose to link to an absolute address. Or, you can link to a range name.
How to link to an absolute address in an Excel workbook
Ms Word To Excel Converter software, free download
In your Word document, do ctrl-F9. Within the braces that Word gives you, type so that it looks like the following:
{ HYPERLINK 'C:My DocumentsMyExcelFile.xls#MySheet!A1' }
If your sheet name contains a space, then you need to enclose it in single quote marks, like this:
{ HYPERLINK 'C:My DocumentsMyExcelFile.xls#'My Sheet'!A1' }
Alternatively, you can use the l (that's a lower-case L) switch to identify the range name:
{ HYPERLINK 'C:MyDocumentsMyExcelFile2.xls' l 'Sheet 1'!A1' }
How to link to a range name in an Excel workbook
To create a hyperlink to a Worksheet range name, use use ctrl-F9 and type so it looks like the following:
{ HYPERLINK 'C:My DocumentsMyExcelFile2.xls#'Sheet 1'!RangeName' }
To create a hyperlink to a Workbook range name, use use ctrl-F9 and type so it looks like the following:
{ HYPERLINK 'C:My DocumentsMyExcelFile3.xls#RangeName' }
However…..
Word wouldn't be Word if it were always that straight-forward! Excel gets confused if you have both a Workbook range and a Worksheet range with the same name. It seems to link to the range randomly. So, if you use range names, make sure they're all sheet-specific or all workbook-wide. Or use an absolute address.
How to add a screen tip to a hyperlink
You can use the o switch (that's a lower-case O, not a zero) to create a tooltip, like this:
{ HYPERLINK 'C:My DocumentsMyExcelFile3.xls#RangeName' o 'Click here to open MyExcelFile3' }
Related subjects
Topic: Word and Excel
Interest: For users
Version: Word 2000Word 2002Word 2003Word 2007Word 2010
Created April 2006. Last updated 21 July 2010.