For example: I want every cell in column D to equal the value of cells A + B in each row. So D1=A1+B1, D2=A1+B2 etc. I want to do it without entering the formula for each cell in D individually. Thank you.
2007-01-22 01:24:26 · 3 answers · asked by absynthian 6 in Computers & Internet ➔ Software
Does this help:
http://www.xexcel.wyzguys.net/13FillCells.htm
2007-01-22 01:28:34 · answer #1 · answered by Mictlan_KISS 6 · 0⤊ 0⤋
Do a copy and paste of the first formula and it will automatically change when you paste it in the next cell for example
If you have this formula in cell D1 =a1+b1=c1 and then you copy and paste it in cell D2 it will automatically turn =a2=b2=c2
2007-01-22 01:34:38 · answer #2 · answered by Love United 6 · 0⤊ 0⤋
Hi,
Enter the formula in the first cell. Copy the formula. Then select range of cells you want the formula to appear. Go to Edit and then Select Paste Special. Select Formula and press enter. The formula will get applied to the enttire range of cells you have selected.
2007-01-22 01:31:28 · answer #3 · answered by The Storm Chaser 3 · 0⤊ 0⤋