How to connect Word and excel data in office

1.Open Excel and Word worksheets first, copy the data of Excel worksheets, and then return them to Word worksheets. Move your mouse to the menu bar in the word worksheet, you will find there is a "" option, click on it.

After clicking on it, many options will be pulled down, and in the drop-down options, click the "Paste Selective" button.

<>3.After selecting the "Paste Link" option, it will appear as shown in the figure, then we select "Microsoft Office Excel Worksheet Object" on the right, and click the OK button above after selecting it.

4.After clicking the OK button, you can see that the word document has changed, and the Excel data has been referenced, so save the word document and close it.

5.Close word can test whether the data can be updated synchronously, modify the data in the excel worksheet, as shown in the figure: there is no value in the column greater than 80 before, and then you can see that this column has been modified by us.

<>7.After clicking the "Yes" button, you can see that the data of the Word worksheet has also been updated, which means that the synchronization update of Excel and Word data has been set successfully.

In Word, click Insert - Object - select Excel, double-click it, click Elsewhere, and it can be displayed statically.

1. Establishment"So-and-so. doc"Template.

First, make a template using word and save it as "."So-and-so. doc"", and insert the data you want to insert (e.g., Data 1, Data 2, ......) to vacate first.

2. Use Excel to establish the corresponding database.

Set the data (data 1, data 2) and other related information to be inserted into the word document in Excel** and save it as "so-and-so. xls”

3. Linking databases and awards.

Turn on "So-and-so." doc, select View Toolbar Mail Merge, select Open Data Source in the newly appearing toolbar, and select So-and-so. xls", open it, select the corresponding workbook, the default is sheet1, and press OK.

Position the pointer to the place where you want to insert data (such as data 1), click Insert Field, select (Data 1) in the pop-up dialog box, and press Insert. The same method accomplishes the insertion of other data.

4. Preview and print.

Select "View Merge Data", and then use the front and back arrows to explore the effect of the merged data, if you are in batches, you can select "Merge to New Document" to generate a word document containing all so-and-so, and then you can print in batches.

Here's how:

1. First open Excel**, select all data, right-click and select "Copy".

2. Then open Word, create a new blank Word document, right-click, and select "Link & Keep Source Format" in the paste option to paste.

3. If you paste it with the shortcut key Ctrl+V, you will see a Ctrl drop-down key appear next to it, click on it, and then select "Link & Formatting".

4. Click on the data in word to make all the data gray, and then enter Excel, click on the data we want to modify, and then enter the data we modified.

5. After the input is completed in excel, click elsewhere in excel to generate the data of the cell, and then you will find that the data in the document has been the same as the modified data in **.

6. After the modification, just save them. When you open the word document again, you will be prompted to update, click "Yes".

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.

Implementing the Word and Excel association usually refers to data synchronization.

2.Copy the data of ** into word;

3.Click "Smart Label" in the lower right corner to select the [Connect and Preserve Source Format] pasting option;

4.When you change the data in Excel**, the data in the word text has been automatically changed, and the effect is as follows:

Insert Object Created by File Browse Select the **file you want to insert OK

Open Excel - Copy Data, Open Word, Don't paste directly, but select the link in the top left corner with keep the source format or Link with the use target format.

Both are consistent with the excel data, except that the first one retains the format of the original data, while the latter does not

I don't know if you're going to 1Put the data in excel in a word document, or 2Connect from a Word document to Excel.

If it is 1, copy ecxel directly and paste it into word;

If it is 2, you need to select Insert --Object, and then select it.

Don't know what can help you not.

Take advantage of the mail merge, you will do it in this tutorial.

Link or embed excel sheets.

If you want to create a dynamic link between the content of a document and the content of a Microsoft Office Excel workbook, you can insert the content as an object. Unlike pasting content, such as by pressing Ctrl+V, when you insert content as a linked or embedded object, you can work with the content in the original program.

If you insert a cell into a document as an Excel object, Microsoft Office Word runs Excel when you double-click the cell, so you can use Excel commands to work with the worksheet contents.

If you insert an entire Excel sheet as an object, only one sheet will appear in the document. To display a different worksheet, double-click the excel object, and then click the desired worksheet.

There are two ways to call Excel data in Word, one is OLE (linking and embedding of objects) and the other is DDE (Dynamic Data Exchange). OLE is used to embed excel data directly into a word document, which can be understood as a dataset that exists in word. DDE is a protocol that allows two applications to exchange data continuously and automatically over a DDE "channel".

To control the DDE session between two applications, you need to set up a channel, select a topic, request and deliver data, and then close the channel. The following two ways to refer to Excel data are explained.

Tools Raw materials.

Microsoft Office 2007.

Method steps.

1 7 Step by Step Reading.

Prepare raw data. In order to illustrate to you how Word can cite Excel data, first create a file called"Basic information of employees. xlsx", which contains several records, each of which includes attributes such as "Name", "Gender", "Level", "Expertise", and "Department".

2 7 When the raw data is ready, the next thing to do is to cite the data in Excel in Word. The specific implementation method is: firstly, select and copy the data area to be referenced in the Excel document, then select "Start" in the Word document, click the "Paste" drop-down list, select "Paste Special" from it, check "Paste Link" in the pop-up window, and select "Microsoft Office Excel Document Object" on the right side, click "OK" to complete the operation of referencing Excel data.

See the remaining 2 images.

3 7 At this time, if the content in the excel document changes, for example, change the "advanced" in the "level" attribute to "level", you will find that the corresponding content of the word document will also change immediately, so as to realize the synchronous update of the data.

4 7 use the above-mentioned method to realize the reference of word to excel data, there is an obvious shortcoming in that the reference data is not arbitrary, that is, the obtained data can not be displayed and output according to the custom format. In order to be able to refer to data in Excel more flexibly, it is necessary to use DDE (Dynamic Data Exchange) technology. DDE is a protocol that allows two applications to exchange data continuously and automatically over a DDE "channel".

To control the DDE session between two applications, you need to set up a channel, select a topic, request and deliver data, and then close the channel. Let's take a look at how to use DDE to reference data from Excel to Word.

There are two ways to call Excel data in Word, one is OLE (linking and embedding of objects) and the other is DDE (Dynamic Data Exchange). OLE is used to embed excel data directly into a word document, which can be understood as a dataset that exists in word. DDE is a protocol that allows two applications to exchange data continuously and automatically over a DDE "channel".

To control the DDE session between two applications, you need to set up a channel, select a topic, request and deliver data, and then close the channel. The following two ways to refer to Excel data are explained.

Tools Raw materials.

microsoft

office

There is a big shortage of office software.

Method steps.

xlsx"contains several records, each of which includes attributes such as "Name", "Gender", "Level", "Specialty", and "Department". In specific applications, there may be more attributes and content, which are just a starting point. The raw data is shown in the figure.

When the raw data is ready, the next thing to do is to cite the data in Excel in Word. The specific implementation method is as follows: first select and copy the data area you want to reference in the excel document, then select "Start" in the word document, click the "Paste" drop-down list, select "Paste Special" from it, tick "Paste Link" in the pop-up window, and select "Microsoft" on the right side

office

Excel documents.

object", click OK to complete the operation of referencing Excel data.

See the remaining 2 images.

At this time, if the content of the Excel document changes, for example, change "Advanced" to "Level 1" in the "Level" attribute, you will find that the corresponding content of the Word document will also change immediately, so that the data can be updated synchronously.

There is an obvious shortcoming that uses the above-mentioned method to realize the citation of Excel data in Word, that is, the cited data is not arbitrary, that is, the obtained data cannot or is inconvenient to display and output according to the customized format. In order to be able to refer to the data in Excel more flexibly, it is necessary to use DDE (Dynamic Data Exchange) technology to implement it. DDE is a protocol that allows two applications to exchange data continuously and automatically over a DDE "channel".

To control the DDE session between two applications, you need to set up a channel, select a topic, request and deliver data, and then close the channel. Let's take a look at how to use DDE to reference data from Excel to Word.

You're talking about this that requires inserting objects.

In Word, click on Insert - Object - Create from File - Click "Browse" in File Name Scatter to select the file you want to insert,—— check "Link to File" type - OK. Implement a link to excel in Word and display it in its entirety.

Mind you, you'd better be x

The three worksheets should not be in the same workbook.

If you want to update the new data of the rent, you need to right-click ,—— update link.