Basically I am facing some problem due to excel auto generate formula that is wrong in such situation. The formula at B6 is =A6*B1. Then the rest of the rows are using cursor bottom right drag down. I want B6 onward to all have *B1.

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.

By dragging down to the bottom excel autofill's B1 as in numbering to make it B2, B3, B4
What you can do is for every calculation you can do it manually select B1 e.g
=A7*B1 ... this is what you do type = then select A7 type * then select B1 ... then press enter