Through the cell in Excel formula automatically enter the corresponding results obtained, but if you want to use a simple copy and paste the results of the command will be moved to other locations, it is not possible, because you copy and paste the formula instead of computing the result, it moved to a new location will be the additional number of calculations.
Can be taken two ways: First, results will be copied to a Word document, which most insurance. Second, the results in the calculation of a change in Excel’s default settings: In the “Tools / Options / re-calculation” dialog box to select “manual re-count” and “Save before automatic” on the hook before removing, and then you can form in the original copy of any of the data. One thing to note, however, it is best to move to the new location of the data and then print them out, because once the “artificial re-considered as a” back to “automatic”, then move the data will be wrong.
| Use formula used to find duplicate data in Excel sheet |
| How to automatic summation in Excel |
| excel summation |
| EXCEL calculation error message |
Try a copy, then a Paste special, paste value