Printable View
Hi,
I created a excel file Microsoft excel 2007 and now i want transfer all the data in to word in the same format in which it exists in excel. is it possible , I have created chart or graph to process data In that Excel file. is there any programs of the Office suite work together to insert a table or an Excel chart into a Word document.
If you want to Insert Excel data into Word, the most practical method is to use the Paste Special function that preserves the original values of any modification in the Excel document source and will be automatically reflected in the Word document. You'll have the information constantly updated.
If you want to recover a table or graph Paste Special in Word, will do the trick for you, you can insert elements in your Excel documents.
- In Excel, open the workbook that contains the table to copy.
- Select the data to use.
- In the Home tab of the Office Ribbon, click the Copy button.
- Open your Word document and place the cursor where to put items from Excel.
- In the Home tab of the Office Ribbon, click the arrow under the Paste button and choose the Paste Special command
- Select Paste Link.
- Then select Microsoft Office Excel Worksheet Object from the As list.
- Click the OK button: the picture is then inserted to the desired location.
- Back in Excel. Click on the graphic to insert in Word.
- In the Home tab of the Office Ribbon, click the Copy button.
- Open your Word document and place the cursor where to put the chart from Excel.
- In the Home tab of the Office Ribbon, click the arrow under the Paste button and choose the Paste Special command.
- Select Paste Link.
- Then select Microsoft Office Excel Chart Object from the As list.
- Click the OK button: the graph is then inserted to the desired location.