Given that I have the following data in sheet1:

| id                                   | red |
| e6282843-efc0-44f6-8989-028153adc317 | yes |
| 014c7590-5c3f-4260-b251-5098dd825688 |     |
| 6a037de4-0dc6-4e67-966b-7d6187b9d93b | yes |

I know that by entering =sheet1!A2 in sheet2 column I can grab the data and then dragging the formula will expand it as far as I want. But is there a better to sync two columns without specifying the range?

Basically, I want a column to be cloned and updated in another sheet without expanding the formula. Every time something is added to first column it should reflect on the second column.

1 Answer 1


This sounds like a job for ARRAYFORMULA. Enter this in your Sheet 2 cell, where you want the values copied to:


When you enter new values in Sheet 1, the new values will automatically be present in Sheet 2. Only the A2:B range is included.

Feel free to copy this spreadsheet that I set up to test, and check the documentation for ARRAYFORMULA.

  • Awesome. Saw the arrayformula earlier but couldn't figure out how to use it. Thanks.
    – Sam R.
    Dec 18, 2015 at 22:47
  • Yeah, arrayformula is in no way obvious. Glad you could use it! Dec 18, 2015 at 22:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.