Home

Matching formula from reference cell?

Highlighted
RandomKSM
New Contributor

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.

4 Replies
Highlighted

@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.

 

Highlighted
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?
Highlighted

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

Highlighted

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.

Related Conversations
Cannot enter sources
AndreasDK1982 in Office 365 on
0 Replies
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies