Hi,

this question is not clear. But if I use you subject line as the question:

Suppose that the range you want to multiple is A1:A10 and you want to
multiply it by the value in cell E1. and you want the results in B1:B10, then

Highlight the range B1:B10, type =E1*A1:A10 and press Shift+Ctrl+Enter.

This is not the standard way to do this but it works an takes less memory.
the standard way would be =E$1*A1 and copy that down to B10.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kenny" wrote:

I want to make a budget analysis we I can input a dollar figure in one cell
and multiply to times a range of cells. When I copy the formula excel
correlates the cells to the next in line.