How to set a cell is a formula equal to another cell?

Web Applications Asked by Romulus Urakagi Ts'ai on August 20, 2020

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?

One Answer

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.

Answered by Erik Tyler on August 20, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP