I have a sheet of formulas, and I want to duplicate it several times for different data set. If I use ='Sheet1'!A1 in A1 of Sheet2, it will copy the value but the formula.

Is there a way to copy formulas, and all copied formula cells will change if you modify the source cells?

  • 3
    There is no built-in feature that does that, but you could use Google Apps Script. – Rubén Nov 25 '18 at 17:56

It's not 100% clear to me what you are asking. But your best approach may be to simply right-click the original sheet name at the bottom (in the tab) and choose "Duplicate." This will create a new sheet with all of the same formulas in it.

You can also select the range of formula cells from Sheet1, hit Ctrl-C to copy to clipboard, then click in the upper left cell of the same range in Sheet2 and hit Ctrl-V to paste. The formulas will be pasted exactly as they were in the Sheet1.

  • docs.google.com/spreadsheets/d/… This is a sheet I want to modify, it has seven sheets with the same formulas and format, with seven set of different data. Then, if I want to modify some formula cells in it, I need to copy and paste six times each time. If there's a way like =FORMULA('SheetFormula!A1'), I don't need to copy and paste. – Romulus Urakagi Ts'ai Nov 26 '18 at 1:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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