Skip to main content

New Article

How to SUM by matching partial text in Excel

Post a Comment

How to use Excel in Microsoft Word or others Office application?

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:

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.
Labels:

Popular posts from this blog

How to display an image in worksheet based on a List or based on IF condition?

Excel can show image on worksheet based on a specific IF condition. So, how to do it? Simple follow the below steps: Step by Step: Step 1: Insert images in your Excel Worksheet. Here I've inserted 5 different types of balls, Football, Cricket, Pool, Basketball, Tennis ball. Note that, All balls are placed into different cell. These are placed in Picture sheet. Image 1: 5 balls placed in 5 different cells and covered photo's wide and height Step 2: In the report sheet, design the report as you wish. I've designed in my way like below: Image 2: Kids asking to Donald Duck, which ball need to throw now Step 3: Make a drop down list "Games" in E6 cell in Report sheet from Data Validation. which is as below: Football Cricket Pool Basketball Tennis You can do an IF function here in E6 in Report sheet, which will meet a certain condition and returned Football, Cricket, Pool, Basketball or Tennis. Step 4: Now the tricky part is...
Read more

Cumulative Closing Balance like a Bank Statement in PivotTable

A Bank Employee in many case needs to calculate the Closing Balance after each transaction in PivotTable like a Bank Statement . But with the help of Calculated Field of a PivotTable , you can only calculate Field with Field . It's not possible to use a formula in Calculated Field where you can mention a single cell with Relative Reference Cell . Because a PivotTable acts like a Table format where you can work with Field or Column Name . A Helping Column (A regular column, that helps to get a partial result where formula applied) can be a good idea. But there is an option in PivotTable by which you can Calculate Cumulative . In this article I will show you, how you can do it. Calculating with Formula: Assume that, you have an Excel file with Debit and Credit transaction of an Account . Image 1: Sample Bank Statement In a Bank Statement , Month wise Cumulative Balance is important. In the Excel sheet, as above, it is very easy to use a formula and calc...
Read more

Value Paste and Formula Paste

In many case, in our professional life, we need to do Copy and Value Paste or Copy and Formula Paste in all most always. Those employees, who works under MIS Department, have to do it lots of time in a single day to prepare reports. It is very time costing task in Office. Many of us use Excel Menubar to do it, others are using Keyboard Shortcut by pressing ALT key (like for Value Paste Press ALT+H+V+V and for Formula Paste Press ALT+H+V+F ). But did you noticed that, these two ways strongly need your attention to do this task. More clearly, if you choose Value Paste from Menubar , then what you need to do? First you should take the mouse in Hand Wheel the mouse in Home menu Then Click on Paste Then you pressure your eyes to find the Value Paste icon And then Click on it to paste it These all steps can take more than 1 second. Am I right? Below is an image of this process: Image 1: Value Paste from Home Menu On the other hand, if you choose the shortcut f...
Read more