How to Copy Value from One Cell to Another in Excel Using Formula: A Guide

Copying value from one cell to another in Excel using a formula is a handy trick. The quickest way is to use the simple "=" formula. Just type "=" in the target cell followed by clicking the cell you want to copy from. Hit enter, and voila! The value appears. This method keeps the cells linked, so any changes in the original cell reflect in the target cell.

How to Copy Value from One Cell to Another in Excel Using a Formula

In this tutorial, you’ll learn how to copy the value from one cell to another using a basic Excel formula. This is a useful skill for managing data efficiently. Let’s break it down step by step.

Step 1: Open your Excel file

First, open your Excel file where you want to copy the value.

Opening your Excel file is as simple as double-clicking it. Make sure you know where the file is saved on your computer.

Step 2: Select the target cell

Next, click on the cell where you want the copied value to appear.

It’s important to know which cell you want the data to go to, so make sure you’ve planned this out in advance.

Step 3: Type the formula

In the target cell, type "=" and then click on the cell that contains the value you want to copy.

When you click on the source cell, Excel will automatically insert the cell reference into the formula. For example, if the value is in cell A1, your formula will look like "=A1".

Step 4: Press Enter

After you’ve typed the formula, press Enter.

Once you press Enter, the value from the source cell will appear in the target cell, and any changes to the source cell will reflect in the target cell as well.

Step 5: Check the copied value

Finally, verify that the value has been copied correctly.

Double-checking ensures that you’ve copied the right information and that it displays as expected.

Now that you’ve completed these steps, any changes made to the original cell will automatically update in the target cell. This keeps your data synchronized.

Tips for Copying Value from One Cell to Another in Excel Using a Formula

  • Always double-check the cell references to make sure they’re correct.
  • If you copy formulas to other cells, use absolute references (e.g., $A$1) to keep the reference fixed.
  • Remember that if you delete the original cell’s content, the target cell will show an error.
  • Use the ‘Paste Special’ feature if you need to copy only the value without linking the cells.
  • Keep an eye on circular references, which can cause errors in your spreadsheet.

Frequently Asked Questions

What happens if I delete the original cell’s content?

The target cell will display an error, typically a #REF! error, because the formula no longer has a source.

Can I copy the value without linking the cells?

Yes, use ‘Paste Special’ and select ‘Values’ to copy only the value.

How do I use absolute references in my formula?

Type a dollar sign ($) before the column and row references (e.g., $A$1) to keep the reference fixed when copying the formula.

What if the source cell contains a formula?

The target cell will show the result of that formula, not the formula itself.

Will the format of the cell be copied as well?

No, only the value is copied. You’ll need to format the target cell separately.


  1. Open your Excel file.
  2. Select the target cell.
  3. Type the formula by entering "=" and clicking the source cell.
  4. Press Enter.
  5. Check the copied value.


Copying value from one cell to another in Excel using a formula is a simple yet powerful tool that can save you a lot of time. Whether you’re managing a massive dataset or just trying to keep your daily tasks organized, mastering this technique will make your life easier. Remember, the "=" formula keeps cells linked, so any changes in the original will update the copied cell automatically. This can be a double-edged sword, though, as deleting the original content will cause an error in the copied cell. So always double-check your references and consider using ‘Paste Special’ when you need just the value. Happy Excel-ing!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy