| |
|
|
MS Word and Excel 1997-2003 and 2007. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- The Word file and Excel file should be on your hard drive – My Documents for example. Copy and place them there if they are on portable storage (i.e memory stick).
- Open Word and Excel and keep them open.
- Open each file in it’s respective program.
- Select and copy required part of spreadsheet in Excel.
- Use Paste Special in the Edit menu in Word to paste the Spreadsheet section at the required cursor position.
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
 |
|
| |
In Paste Special select
"Microsoft Office Excel Worksheet Object" |
|
| |
|
|
|
|
If you plan to transport the Word file for use on another computer, you will need to remember to include the Excel file so you can link the data again if required. |
|
| |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Excel cells required for the Word document. |
The copied Excel cells in Word using paste special. |
|
| |
|
|
|
|
|
|
|
|
|
The files are linked and updating the Excel file and saving it will automatically update the Word file when you open it.
NOTE: – If the files are moved to other folders the process has to be redone.
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
MS Word 2007 and MS Excel 2007
The method is the same as above - Paste Special is accessed from the Home tab on the ribbon in Word 2007 (right). |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
