我有这样的表。
A B C ...K.....P Q R S T
5 2 7 ...3
页: 1
I want P1=A1*K1 (I can do that by typing =A1*K1 in P1 - no problem so far). Then I want Q1=B1*K1, R1=C1*K1 and so on. Only one of the two items is changing (K1 remains constant). If I drag the cell P1(after typing = A1*K1), it increments both the operands of multiply, so Q1 becomes (B1*L1), R1 becomes C1*M1. I want the first operand to increment normally, but second one should remain K1.
一旦这样做,我就必须能够把第1行rag倒,以便所有各行都发生类似情况。
How can I do that ? Thanks in adv.