Dynamic Subtraction formula in excel sheet

Question

In order to dynamically subtract cells from one another within the same column, I need to create a formula in Excel.

For example, A2 = A1 - G1 (G column is fixed)

    and  A3    =     A2   -    G2
   
    and  A4    =     A3   -    G3

Answer 1

Excel is capable of using both a relative reference to the current cell and a dynamic reference. For instance, if you enter =A1-G1 in cell A2 and drag this cell down using the square, all subsequent cells in column A will immediately receive the same formula.

Video example: Copy cells and keep formulas relative to current cell