Anatomy of Word: Using Excel information in Word documents
Paste Special lets you paste your Excel data as Excel data rather than as a Word table
So how do you accomplish this seemingly magical feat? First, open Excel and select the data range that you want to include in your Word document. Once selected, press the Copy button (or press Ctrl V, or choose Edit | Copy). Now, back in Word, place your insertion point at the location at which you want to place the Excel information. From Words Edit menu, choose Paste Special, which opens the window shown above.
From the Paste Special window, choose the Paste radio button at the left and, from the "As" box, choose "Microsoft Office Excel Worksheet Object". Next, click the OK button.
Once you copy information from an Excel worksheet into Word using this method, the information is no longer tied to the original Excel workbook. That means if you make changes to the information using Excel directly, those changes will not be reflected in your Word document. However, the third method to include Excel information in your Word document can assist with the problems that may be created by this limitation.
From the Paste Special window, choose the Paste radio button at the left and, from the "As" box, choose "Microsoft Office Excel Worksheet Object". Next, click the OK button.
Once you copy information from an Excel worksheet into Word using this method, the information is no longer tied to the original Excel workbook. That means if you make changes to the information using Excel directly, those changes will not be reflected in your Word document. However, the third method to include Excel information in your Word document can assist with the problems that may be created by this limitation.
