G Guest Nov 11, 2004 #1 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.
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.
G Guest Nov 11, 2004 #2 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.
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 Nov 11, 2004 #3 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!
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!
