How To Copy Cell Value In Excel Using Formula

In this article, I will tell you how to copy one cell value or a cell range value to another cell or another cell range using a formula with examples.

1. How To Use Cell Reference To Copy Cell Range Value To The Same Or Other Worksheet.

  1. Below is the source cell range, suppose the below cell range’s worksheet name is worksheet1.
  2. If you want to duplicate the above cell range A1:A5‘s value in the current worksheet, then you can input the formula =A1 in that cell such as cell C1.
  3. And then click to select cell C1 and drag the small square on cell C1‘s bottom right corner to cell C5.
  4. Then it will add a formula in each cell of cell range C1:C5.
  5. And then it will copy the cell range A1:A5 text value to cell range C1:C5.
  6. If you want to copy the cell range A1:A5 to another worksheet such as worksheet2.
  7. Then you should open worksheet2 and input the formula =’worksheet1′!A1 to the cell in worksheet2.
  8. And then you can repeat steps 3,4, and 5 to copy the A1:A5‘s value to worksheet2.

2. How To Use Other Excel Function To Copy Cell Range.

  1. Besides using the cell reference, you can also use other excel functions to duplicate cell range.
  2. For example, you can input the formula =VLOOKUP(A1, A1,1, FALSE) in cell C1, then you can use the autofill feature to copy the cell range.
  3. You can also input the formula =CONCAT(A1) in cell C1 and then autofill the other cells in cell range C1:C5.


  1. How To Use VLOOKUP In Excel.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.