i'm trying to get a simple formula A1*C2 (C2 being the non changing cell) to follow down loads of columns.
eg. A2*C2, A3*C2, A4*C2 etc etc
by clicking the right bottom corner and drag down, it increases the value of both cells involved.
can someone help? (i'm sure this is an easy one...)