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. :P


    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


    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!

Register Yourself Login