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.
- Below is the source cell range, suppose the below cell range’s worksheet name is worksheet1.
A 1 Excel 2 Word 3 PPT 4 Outlook 5 Access - 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.
- And then click to select cell C1 and drag the small square on cell C1‘s bottom right corner to cell C5.
- Then it will add a formula in each cell of cell range C1:C5.
- And then it will copy the cell range A1:A5 text value to cell range C1:C5.
- If you want to copy the cell range A1:A5 to another worksheet such as worksheet2.
- Then you should open worksheet2 and input the formula =’worksheet1′!A1 to the cell in worksheet2.
- 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.
- Besides using the cell reference, you can also use other excel functions to duplicate cell range.
- 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.
- You can also input the formula =CONCAT(A1) in cell C1 and then autofill the other cells in cell range C1:C5.
Reference