There are several different ways that you can copy data from Excel into Word. The method you choose will depend on the functionality you want to retain once the data has been imported. For example, if you do a simple copy and paste, you can edit the imported Excel data as any other Word table. However, if you want to be able to edit that data within Excel and have those changes updated automatically in Word, you can do so by creating a dynamic link.
- Open your Word document.
- Open your Excel spreadsheet.
- With Excel, select the cells you want to copy into Word.
- On the Home tab, in the Clipboard group, click Copy.
- Switch back to your Word document.
- Place the insertion point where you want the data placed.
- On the Home tab, in the Clipboard group, click the arrow on the Paste button and click Paste Special.
- Select Microsoft Excel Worksheet Object.
- Select the Paste Link radio button.
- Click OK.
Now when you double click the table in Word, the worksheet will open in Excel.
[tags]excel, microsoft office, excel 2007, worksheet[/tags]