Matching formula from reference cell?

[RandomKSM]

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.

[#2]

---

@RandomKSM wrote:

Unfortunately, the cells are not contiguous so I can't easily drag and autofill.

That suggest a bad model.

You should change your setup.

[#3]

Hi i need help with a range of text say One, two three... to one Million. , how to use auto fill to achieve this pls?

[#4]

Hi, go to home tab, then to the edition subgroup and you'll see an arrow under sum symbol. click on this button and go to sequence

[#5]

Yeah, it grew over time.  Each column has a different way of dealing with potential data but is broken up each day and week for subtotals.  If I drag and autofill, I paste over the subtotals.