microsoft excel apply formula wrongly

Question

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.

What can I accomplich this?

Answer 1

Change the formula in B6 to =A6*$B$1 (note the $'s) This makes the reference to B1 absolute.

Now when you drag it down, the reference to B1 does not change.

For more details, google excel absolute relative reference

Answer 2

Follow these steps

In the paste special menu select Multiply and you are done!

Answer 3

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