Instructions for copying formulas and data between Excel tables

Often you still copy and paste normally with the key combination Ctrl + C and Ctrl + V for each data. But if you need to copy data or formulas to different cells and not adjacent to each other, this will take a lot of time when you have to paste data into each cell one by one.

The following article shows you a trick to help you copy data and formulas quickly.

Step 1: First you need to copy the data from the cell containing the information to be copied by selecting the cell to copy and press Ctrl + C .

Instructions for copying formulas and data between Excel tables Picture 1

Step 2: Keep the Ctrl key and left click on the cells to copy data to. The cells you select are any, you can select multiple cells in different data areas in a sheet.

Instructions for copying formulas and data between Excel tables Picture 2

Step 3: After you've selected the data cells to be copied, press Ctrl + V (or you release Ctrl and press Enter ) the data will automatically paste into the cells. you have chosen.

Instructions for copying formulas and data between Excel tables Picture 3

You can also use this copy method to copy data and formulas to a series of adjacent cells but not near the data to be copied.

First, you use Ctrl + C to copy data, then hold Ctrl and use the mouse to select a range of cells that you need to copy data to. Then release the Ctrl key and press Enter to paste data and formulas.

Instructions for copying formulas and data between Excel tables Picture 4

So with the trick that in the tutorial article, you can copy data and formulas quickly and efficiently.

Good luck!