EXCEL question....

[krunchykrome]

I have a set of data collumns A through I, rows 1-25. I need to take row 2 and multiply every cell by 50. I have to do this with each row (25 total), each row multiplied by a different figure. How can I take row 2, and multiple each cell by 50? I dont want to go into each cell and multiply the number by another.

 

[BespinReactorShaft]

Do the results of the multiplications have to be in Row 2 as well? I think this cannot be done without creating a temp row somewhere else on the worksheet (for which each cell will contain a formula like "=A1*50", of course the fill handle can be used to repeat the formula for all cells in the same row).

 

[krunchykrome]

Originally posted by: ming2020
Do the results of the multiplications have to be in Row 2 as well? I think this cannot be done without creating a temp row somewhere else on the worksheet (for which each cell will contain a formula like "=A1*50", of course the fill handle can be used to repeat the formula for all cells in the same row).

How can I do this?

 

[navo]

In column B, in the first cell corresponding to your data in column A, write =A1*2. Then double-click the little dot at the bottom right corner of the cell and it will apply the formula to the rest of the column.