I have a very large spreadsheet in which I occasionally want to change a specific formula across the board. Unfortunately, the cells are not contiguous so I can't easily drag and autofill.
Is there a way to have one cell be the primary reference formula for the others to match? For example, if I have A1:=A2-A3, how do I have B1, C1, D1 etc all say =A1 and get the function, not the value? I want B1 to be =B2-B3, C1 to be =C2-C3, and so on.
If I change A1 to now be=A2*A3, I want B1, C1 etc do the same.
Currently simply saying =A1 just gives me whatever the result of that function is. If A2-A3 is 7, then every other cell just ends up being 7 instead of its own unique result.