How to Mirror Cells in Google Sheets?

Do you wish to automatically update the changes you make in one cell to be reflected in the other? You can find out how to do it here.

Google Sheets is undoubtedly a useful tool to help you keep details updated wherever you are using a device with web access. You might be aware that similar to Excel offered by Microsoft, there are different tricks and formulas that you can use in Google Sheets. 

Let us consider that you wish that value in a specific cell in Sheet 1 in Google Sheets to reflect in Sheet 2. You wish that when you make the changes in the source sheet, it should reflect in the target sheet as well. This is called mirroring cells from sheet 1 to sheet 2. Here, the source sheet is sheet 1 and the target sheet is sheet 2. Here, you can gain step-by-step instructions on how to do it:

How to Mirror Cells Across Sheets in Google Sheets?

Mirror Cells by Linking

Let us consider that you wish the value that you enter in Cell B 52 in Sheet 1 to reflect in Cell B 52 in Sheet 2. Here is how you can do it:

  1. Enter any value in Source Sheet B 52. Here source sheet is Sheet 1.
  2. Go to sheet 2, which is your target sheet. Here, go to the B 52 cell and click enter. 
  3. When you click enter, you will see your cursor in B 52 cell in Sheet 2 blinking. Here enter “= and go to cell B 52 in Sheet 1 and press enter.
  4. You might wonder how to go to sheet 1 when your curser is in cell 52 of sheet 2. You can go to the source sheet using your mouse.

Now, you will see that any value you enter in cell B 52 on sheet 1 will automatically mirror Cell B 52 on sheet 2. 

So, mirroring cells in Google Sheets is very easy. Even, if you have used a formula in the source sheet, the same will be reflected in the target sheet.