UNSOLVED
J
jaystevenson
1 Rookie
•
114 Posts
0
1743
November 16th, 2003 21:00
MS Excel question regarding products
I have a big excel spreadsheet. I have 300 cells filled up in two different collums. What I want to do is multiply A1 by B1 then A2 by B2 then A3 by B3 then A4 by B4, etc. (I hope you get the point). However, without a shortcut, this would require me to manually enter 300 different formulas.
There has got to be a quicker way to do this. Any help?
By the way, I already looked for help within the software program.
Thanks, in advance.
JRosenfeld
2 Intern
•
4383 Posts
332
0
Posted November 17th, 2003 21:00
Or just enter the formula in the cell C1, click on that cell, then with the mouse on the little black square on bottom right, double click. It will fill all cells in C with the formula, up to the last row that has entries in columns A and B.
abach
1728 Posts
332
0
Posted November 16th, 2003 23:00
Try an array. Select the first cell where your formula will be, type the formula, then press Ctrl-Shift-Enter to enter an array formula. (Notice the curly brackets)
Next select the range (including the cell you just entered the formula into) of cells that you want to show the calculation. (You can do this easily by going to the Range Name Box and type the first cell, a colon, then the last cell reference and press Enter). When the range is selected, press Ctrl-D to fill the range down.
Your formula will be entered and you'll save a lot of memory, as Excel only had to calculate once. Check out array formulas in online help