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?
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
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
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
Don’t have an account yet? Register yourself now and be a part of our community!