Basically I am facing some problem due to excel auto generate formula that is wrong in such situation. The formula at
=A6*B1. Then the rest of the rows are using cursor bottom right drag down. I want
B6 onward to all have
But, when I use the cursor drag down, the formula is applied as:
=A7*B2 =A8*B3 =A9*B4
I want all of the cells to be multiplied by
B1 and not have it increment.
What can I accomplich this?