Put the value to multiply by in a spare cell, and copy that cell.
Select the range to be multiplied.
Goto editPasteSPecial and select Multiply.
Exit and clear that first cell.
"a" wrote in message
How multiply more cells in same time