Tips: How to Copy a Column That Contains a Formula

In working in Microsoft Excel, sometimes we want to copy a column that contains numbers, where the numbers are the result of a calculation of the other columns. When we tried to copy it to the other columns, it does not appear the original, but a row contains of zeros.
Look at the picture.


From the picture, column C (result) is the product of columns A (Num A) and column B (num B). Then when we try to copy the entire results of column C to column F, then emerges is a row of zeros, This happens because you are not just copying the numbers, but also copy a formula that is contained in each cell of column C, so the formula is brought into column F. So in column F, the formula is formed automatically, as an example for line 2 "= D2 * F2". So in column F, the formula is formed automatically, as an example for line 2 "= D2 * F2". Whereas in column D or column E does not contain the number that corresponds in columns A and B.

If you take a shortcut by re-typing all the numbers in column C one by one, of course it would be troublesome, or you try to copy all the numbers in columns A and B to equalize the condition, know that it's not a good solution.Follow the simple steps below. :

1. Copy the entire column that you want to copy (in the example above is a column C). Press Ctrl + C as a shortcut.  

2. While copied column appear a dotted line, open the Microsoft Word program.  

3. Now Paste the copied column to New Microsoft Word Document. Then all the data contained in Microsoft Excel is now in Ms Word.  

4. Select all the data table in MS Word and then press the copy (Ctrl + C). To select it, press the plus arrow sign  in the upper left corner of the table. see the picture below!  

5. Reopen your Ms Excel  tab and paste (Ctrl + V)  in column F. then you will find that the work has been successful.