cell A-Z x cell B, how to do it simple?

[ronnyo]

I have a long column of numbers. ex. A1, A2, A3.... I allso have one cell with a specifik nuber, lets call it D5. In the cell next to the right of ex. A1, B1 in this case, I want it to multiply A1 with D5. The next B3, B3, B4.... cells should be A2*D5, A3*D5, A4*D5 and so on.

The first one is easy, but I can not find a way to make that formulla for all the cells in the B column.
If I ctrl+drag it changes not just the Ax but allso the D5 wich I do not want.

How do I make this in an easy way? Thanks!

[ken johnson]

=A1*D$5 in B1 will change to =A2*D$5 when filled down to B2. The $ sign stops the 5 in D$5 from changing when the formula is filled down.

Ken Jonson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[ronnyo]

Thanks a lot!