How to insert hyperlinks to Word Documents/files in Excel?
Hyperlink is an easy way to skip to destination cell, webpage, or open specified files in Excel. Do you have any idea about inserting a hyperlink to a Word document? And what if batch inserting multiple hyperlinks to all Word documents in a specified folder? The following methods will guide you to solve them.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
We can add a hyperlink to a Word document in Excel easily with Hyperlink feature. You can do as follows:
Step 1: Select the cell you will add a hyperlink, and then click Insert > Hyperlink.
Step 2: In the opening Insert Hyperlink dialog box, click the Browse for File button , in the popping Link to File dialog box find out and select the Word document you will link, and then click the OK button.
Step 3: In the Insert Hyperlink dialog box, click the OK button to insert the hyperlink.
Then you will see the specified hyperlink is added to selected cell as below screen shot shown.
Sometimes, you may want to batch add multiple hyperlinks to all Word documents or files in a folder. In this case, you can apply Kutools for Excel’s Filename List utility to get it done.
Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel
Step 1: Click the Kutools Plus > Import / Export > Filename List.
Step 2: In the popping File name List dialog box, you need to:
(1) Click the Browse button to open Browse For Folder dialog box, and then specify the folder in which you will add hyperlinks to all Word Documents.
(2) Check the Create hyperlinks option;
(3) Check the Specify option, and then type docx in the below box;
Step 3: Click the OK button to apply the Filename List utility.
Then you will see multiple hyperlinks are batch added to all Word documents in the specified folder in a new worksheet. See below screen shot: