multiplying numerous cells

B

Becky

How do I multiply a range of cells such as A1-G6 by a number such as .105 and
get an individual answer in each cell.
 
T

tjtjjtjt

Put .105 in a cell. Click on it and then Copy it.
Select all the cells for which you want to multiply.
Go to Edit | Paste Special, Multiply.
tj


This method will replace the origianl values.
 
D

Domenic

Becky said:
How do I multiply a range of cells such as A1-G6 by a number such as
.105 and
get an individual answer in each cell.
Click to expand...

1) Enter .105 in an empty cell

2) Select and Copy that cell

3) Select A1:G6

4) Edit > Paste Special > Multiply

5) Click OK

Hope this helps!
 
Top