B Bob Phillips Jan 7, 2010 #2 Put the value to multiply by in a spare cell, and copy that cell. Select the range to be multiplied. Goto edit>PasteSPecial and select Multiply. Exit and clear that first cell.
Put the value to multiply by in a spare cell, and copy that cell. Select the range to be multiplied. Goto edit>PasteSPecial and select Multiply. Exit and clear that first cell.