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!
You should read it
- Instructions on how to copy formulas in Excel
- MS Excel - Lesson 5: Excel formulas and functions
- Copy, copy data in Excel
- How to color formula cells in Excel automatically
- How to hide formulas in Excel
- Steps to create relationships between multiple tables using Data Model in Excel
- How to display formulas and print formulas in Excel
- Guidelines for importing Chemistry formulas in Excel
- How to fix formulas in Excel, fix data ranges in Excel
- Instructions for hiding formulas in Excel
- How to create an Excel table, insert a table in Excel
- How to create an Excel formula in Notepad ++
May be interested
Comments in Excel - Create comments in Excel
How to hide and hide any text in Word
Copy and move text quickly in Word with the Shift key
Change the direction of text in Word
How to find the position of an open Word file - Display the location of the open file in Word
How to display function arguments in Excel