# Drag Formula For Reference Change

• Is there an easy way to drag all the references to a cell in a formula quickly e.g If i have a formula like this is;

=IF(A1>0, A1+1,A1-1)

and want to drag all the references to the cell A1 to another cell in one go as opposed to one at a time?

• Re: Drag All References To A Cell In One Go

Hi nb-

All references to cell A1 in the formula you gave should upadte automatically when you drag the cell that contains the formula to the right or down.

Similarly for copying / pasting formulas - the references to the cell should be updated automatically... is this not happening?

Ger

_______________________________________________
There are 10 types of people in the world. Those that understand Binary and those that dont.

Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

_______________________________________________

• Re: Drag All References To A Cell In One Go

Thanks, but I am not moving the formula. I want to change the cell it refers to from say A1 which has say 5 in it to cell B27, which has -18.3 in it, while leaving the formula where it is (and leaving the content of cells A1, and B27 alone).

• Re: Drag All References To A Cell In One Go

replace A1 in your formula with B27 or whatever

In formulae, depending on your locale, you might have to replace ; with , or vice versa.

• Re: Drag All References To A Cell In One Go

Thanks, thats the way I have been doing it, but what I wanted to know was if for example, I could hold down a key while dragging a cell reference, and it would move all the references to that cell, not just one.

• Re: Drag All References To A Cell In One Go

Can't you just [CTRL+H] and replace all A1 with B27?

• Re: Drag All References To A Cell In One Go

Quote from nb-

Thanks, thats the way I have been doing it, but what I wanted to know was if for example, I could hold down a key while dragging a cell reference, and it would move all the references to that cell, not just one.

No, not possible. You need to read up up Formula References

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!