See all How-To Articles

How to Mirror Cells by Linking in Excel & Google Sheets

This tutorial demonstrates how to mirror cells by linking in Excel and Google Sheets.

 

mirror cells by linking 5

 

Mirror Cells by Linking

When you work with multiple sheets in an Excel file, you can mirror cells by linking them across sheets. Say that you want to link value from cell B2, Sheet1 to cell B2, Sheet2. To do this, follow the next steps.

1. Enter a value in the source sheet (B1, Sheet1 – in this example, 10).

 

mirror cells by linking 1

 

2. (1) Go to the target sheet (Sheet2), (2) enter = in cell B2, and (3) go back to the source sheet (Sheet1).

 

mirror cells by linking 2

 

3. Click on the original cell in the source sheet (B2), and press Enter.

 

mirror cells by linking 3

 

As a result, cell B2 on Sheet2 is now linked with cell B2 on Sheet1. If you click on B2, Sheet2, the value there is =Sheet1!B2. This means that every time you change the value of B2 in Sheet1, it will automatically change the value of B2 on Sheet2.

 

mirror cells by linking 4

 

Now, change the value of cell B2 on Sheet1 from 10 to 15.

 

mirror cells by linking 5

 

 

If you go back to Sheet2, you can see that value of B2 here is also updated to 15.

 

mirror cells by linking 6

 

Mirror Cells in Google Sheets

You can use exactly the same steps to mirror cells in Google Sheets.