How to copy data from one cell to another in Excel using formula

Microsoft Excel offers a very interesting way to copy data from one cell to another. We can cater to this problem statement by using the reference formula in excel. We can perform the below mentioned way to  copy data from one cell to another in excel:

We’ll learn about this methodology step by step.

To do this yourself, please follow the steps described below;

Step 1 – Excel sheet with a cell with data

– Open the desired Excel workbook containing a cell with a text which can be copied to another cell

Step 2 – Give cell reference

– Now go to the cell where you want to copy, and then type”=”, and then give the reference of the cell which needs to be copied as shown in the image above, and then hit Enter.

Step 3 – Data copied

– Now we can see that the data has been copied