help with formulating a calculation

L

LuAnne 1

I need to multiply A2 against the entire row of 2, b thru k. I would be
greatful for the help.
 
S

Shane Devenshire

Hi,

Select cell A2 and do copy.

Select B2:K2 and choose Edit, Paste Special, Multiply.

If on the other hand you wanted the results somewhere else you could write
=$A$2*B2 and copy it to the right.
 
Top