Click hyperlink in Excel to go to a specific page in Word document

If you have a spreadsheet created in Microsoft Office Excel, creating a hyperlink to a Word document and inserting it anywhere in the spreadsheet is quite simple and straightforward to accomplish. When you click on the hyperlink, the Word document opens up to the first page automatically. You will need to make use of a method that involves bookmarks in Word in order to be able to generate a hyperlink that will go to a certain page.

Step 1

You may open the Word document you wish to access at a specified page by clicking a hyperlink in Excel. Keep scrolling down until you locate the particular page to which you want to create a link. And place the cursor at the top of the page on the chosen page.

Step 2

Click "Insert" at the very top of the Word window, and then click on "Bookmark" near the very top of the Link window. This will create a bookmark. You will be able to make use of the Bookmark window that has appeared.

Step 3

Use the underscore "_" character to separate each of the names that you provide into the box labelled "Bookmark Name" when you create a new bookmark. for example,"Page_no_2".

You must first enable the option to produce hidden bookmarks, which is located at the bottom of the Bookmark window and requires a checkmark to activate it.

To include the bookmark in the Word document, choose the "Add" button and save the Word document.

Step 4

Launch a worksheet, then choose the spreadsheet you wish to connect from inside that workbook. Click the right mouse button on an empty cell, then pick Link from the context menu that appears.

Step 5

The Insert Hyperlink box suddenly appears.

In the box labelled "Text to Display" located at the very top of the Insert Hyperlink window, type the text that you want to clicked in order to open the Word document.

Choose a "Existing File or Web Page" to "Link to" in the drop-down menu. Then Choose the folder that contains the Word document from the “Look in” drop-down box, and after that, choose the file from the Current Folder section by clicking on it.

The name of the currently chosen document is shown in the Address box; after typing the hash symbol (#) at the end of the document's name, enter the name of the bookmark you generated in the step before, number 3. In this instance, I will put #Page no 2 in the box.

Then click the "OK" button.

Step 6

To continue, click the link. It will open the page in Word that you were working on when you added the bookmark.