Add an Excel backlink to your Word document

In addition, it should be noted that if you choose not to link to the Internet, then when presenting, you must ensure that there are both excel files and word files in the computer, and the path you have to set again, otherwise the computer will not be able to help you make up excel files. Thanks a lot!

In Word, click "Insert" - Object "- Created by File" (Browse the file location, the following links to the file and display as icons are checked) - OK".

After this setting is completed, it is to embed excel into Word, and the two become a whole, which can be opened in any computer.

Select "Insert" - "Hyperlink" on the menu bar - find the document you need to add and double-click - OK

Make a folder and put it in the same folder.

Software: Office 2007

2. On the pop-up page, go to the file you want to link to, OK.

3. After setting, press CTRL and click the document name to open the excel file.

Method 2: 1. If you are inserting excel** in Word, you can click the Insert --- Object command in the toolbar.

2. Click "Create from File" - Browse to open the Excel file you want to insert.

3. After inserting, check "Show as icon" - OK. (Note that if you click Link to File, future changes will affect the content of the original document).

The materials we need to prepare are: computers.

1. First of all, we open the required excel** and click on a cell.

2. Then we right-click on the cell to open the "Hyperlink" option.

3. Then we click to select a word document in the pop-up window, and then click OK.

If you directly insert the operation: word menu bar: insert --object--object type, select "excel sheet", click ok, after the excel content is done, the mouse clicks in the non-excel area to become word, and you can double-click the inserted excel area again if you want to double-click the mouse again.

In the word document, "Insert", "Object", "Created by File", "Browse", "Show as icon", OK.

In this way, you can directly link Excel in Word, and you can click directly to open Excel data.

The method of inserting hyperlinks in word and excel is basically the same, the difference is that after inserting hyperlinks in word, you need to press ctrl+left-click to open them, while excel can be clicked directly, now take word to insert hyperlinks as an example:

2.You can also link to a bookmark, which is also on a bookmark in the content of the document, first select the bookmark page that needs to be set, select the bookmark in the insert menu, enter the bookmark in the pop-up "Bookmark" dialog box, and click the "Add" button, return to the word document, click the word that needs to insert the bookmark link and right-click, select the hyperlink in the pop-up menu, click "Location in this document" and select the "Test Page" bookmark just set under the bookmark, and click the OK button. After pressing the Ctrl key, the page goes to the bookmarks page (pictured).

1. Select Chinese characters in word, right-click and select hyperlinks;

1. In Excel, select the cell, right-click and select the hyperlink;

Choose Chinese characters;

Right-click;

Check "Hyperlink";

Specify the target you want to specify in the Link Assignment Window that pops up.

OK.

Select the text or ** you want, right-click - hyperlink - select the content you want to link to.

Word and excel have become a must-have software in everyone's work, many times we need to insert it into a word document in excel, and now we introduce several ways to insert it.

Tools Raw Materials:

Word 2007 and Excel 2007 Method 1:

Open good excel**;

Select the ** that needs to be inserted, and combine the keys Ctrl+C to copy;

Open the Word document, select the location you need to insert, and then press Ctrl+V to paste.

Method 2: Repeat the first two steps of Method 1;

Open the word document, select the location you need to insert, click "Start", "Paste", "Paste Selectively";

In the pop-up dialog box, select Worksheet Object and click OK.

Open Excel**, select the ** that needs to be inserted, key combination Ctrl+C to copy, open the Word document, select the location that needs to be inserted, and key Ctrl+V to paste.

Detailed operation: Step 1: Select Insert - Object in the upper left corner of the toolbar, and the operation dialog box appears.

Step 2: Click in the middle of the dialog box that pops up in the Word document to select Create by File.

Step 3: Click Browse, select the location, and click on the excel sheet where you need it.

Step 4: Click OK, the word document will display the excel** you need, if you need to modify the data in the table, click directly on the cell to modify it in excel.

This can be done in a Word document by hyperlinking, or by inserting Excel**.

2. It is achieved by --- objects, and the insertion of --- objects --- created by the file.

Software version: office2007

Here's how:1Click "Object" in the insert menu:

2.Select the "Create from file" tab, find the excel file, check "Show as icon", and click OK:

3.This inserts an Excel** connection, which can be opened by double-clicking.

Copy the data in Excel, then create a new blank Microsoft Office Word document and open it.

Find "Paste" under the start menu of a blank document in Microsoft Office Word, and select "Paste Special (V)" in the Paste drop-down menu

Under the Paste Special tool, check "Paste Link (L)", Form (A) "Select the worksheet object, and then "OK".

When the data is pasted into the Word document, double-clicking Word** will automatically jump to the Excel sheet.

At this time, we modify the data in an excel sheet at will, click on the blank cell after the modification, and then return to the word document, right-click and select "update link", and the data in word** will be automatically updated.

In Word, Insert --Hyperlink, select Excel where you are inserting

1. Insert bookmarks into the Word document. In Word 2013, open the document and position the cursor to the location you need to jump to, click Bookmarks in the Links group on the Insert tab, enter a bookmark title, and click Add. As shown in the following figure, a bookmark named "Bookmark 1" was added to the document.

2. Right-click the cell that needs to be set hyperlink in Excel 2013, select "Hyperlink", and the "Insert Hyperlink" dialog box will pop up. Find and select the above word document, then you can see the path of the document in the "Address" bar at the bottom of the dialog box, such as "J: document" in this example.

At this time, you can't add a bookmark by clicking the "Bookmark" button, because clicking the "Bookmark" button Excel will pop up a dialog box that says "Microsoft Excel can neither open this file nor parse such a file", the correct way is to add "Bookmark1" directly behind the path, and the address becomes "Bookmark1" at this time: :j:Document Bookmark1

Click OK to close the dialog box to complete the hyperlink settings.

3. If the word document is opened, click the hyperlink in the cell to jump to the position of "Bookmark 1". If the document has not been opened before, and the document is not redirected to the bookmark location after clicking the hyperlink to open the document, click the hyperlink again.

In fact, by adding a " " sign and some text in the document to the end of the path above, clicking the hyperlink will jump to where the text first appeared.

hyperlink("j: Document bookmark 1","Bookmark 1")

or :=hyperlink("j: Document bookmark 1","Bookmark 1")

Method 2: Use Paste Special.

Copy some content near the specified position in the word document, and then right-click a cell in excel for paste special, then the "paste special" dialog box will pop up, you can see that this dialog box is different from the dialog box when you copy it in excel and then paste it specially, select "hyperlink" and OK, so that you can click the cell to jump to the specified position in the word document.