In many thesis or research you need to calculate data in Excel worksheet and present the calculated data with reference in MS Word. But many of us use the Table in MS Word for calculation like MS Excel does. Most of the time we failed because a Table can't do all the things like Excel fast. So, the question is "Is there a way to use the MS Excel spreadsheet in MS Word properly"? The answer is Yes. You can use your Excel in Word. The process is very simple, which described as below:
Sample Excel Worksheet:
Assume that, you have calculated a "HR Salary Sheet" in Excel like below:
Way 1: Copy and Paste Special:
(a) To present it in the MS Word page, just select the data table (B3:I14) cell and press Ctrl+C to copy them.
(b) Now open your MS Word and Click the Paste Special option.
(c) While Paste Special dialog box appears, Select Paste radio button and then Microsoft Excel Worksheet Object and Click on Ok.
The Excel table will display in MS Word like below:
(d) If you wish to re-calculate the Gross salary, then Double Click into the pasted table to activate the Excel spreadsheet window where you can use the Excel functions:
Way 2: Insert | Object:
(a) First of all Copy the HR Salary Sheet (cell range B3:I14).
(b) This is the second to insert the Excel worksheet in MS Word. In your MS Word menubar Click on Insert menu and then Click on Object:
(c) Then a dialog box will appear named Object. Click on Create New and then Select Microsoft Excel Worksheet as shown in the picture below and Click on Ok:
The will create a new Excel spreadsheet in Word application.
(d) Click on B3 cell and then press Ctrl+V to paste the HR Salary Sheet. It will looks like below after pasting:
(e) Now you you need to Edit the pasted table by double clicking on it to adjust it like below:
The 2nd way is difficult due to you have to work on it after paste the data table. But both way are useful to insert your Excel worksheet in MS Word.
Sample Excel Worksheet:
Assume that, you have calculated a "HR Salary Sheet" in Excel like below:
Image 1: HR Salary Sheet
Way 1: Copy and Paste Special:
(a) To present it in the MS Word page, just select the data table (B3:I14) cell and press Ctrl+C to copy them.
(b) Now open your MS Word and Click the Paste Special option.
Image 2: MS Word Paste Special option
(c) While Paste Special dialog box appears, Select Paste radio button and then Microsoft Excel Worksheet Object and Click on Ok.
Image 3: Paste Special dialog box of MS Word
The Excel table will display in MS Word like below:
Image 4: Pasted Excel table in Word
(d) If you wish to re-calculate the Gross salary, then Double Click into the pasted table to activate the Excel spreadsheet window where you can use the Excel functions:
Image 5: Excel Function in MS Word
Way 2: Insert | Object:
(a) First of all Copy the HR Salary Sheet (cell range B3:I14).
(b) This is the second to insert the Excel worksheet in MS Word. In your MS Word menubar Click on Insert menu and then Click on Object:
Image 6: Object in MS Word
(c) Then a dialog box will appear named Object. Click on Create New and then Select Microsoft Excel Worksheet as shown in the picture below and Click on Ok:
Image 7: Object dialog box
The will create a new Excel spreadsheet in Word application.
Image 8: Excel spreadsheet in MS Word
(d) Click on B3 cell and then press Ctrl+V to paste the HR Salary Sheet. It will looks like below after pasting:
Image 9: Pasted the HR Salary Sheet
(e) Now you you need to Edit the pasted table by double clicking on it to adjust it like below:
Image 10: After edited, the table looks like this
The 2nd way is difficult due to you have to work on it after paste the data table. But both way are useful to insert your Excel worksheet in MS Word.