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?