Applying one Formula to Other Cells in the Same Column

This video demonstrates entering a formula in one cell, and being able to apply that same formula to all the cell in that column that have data.

[GXOR_LA]

Thank You very much for this video, it helped me to do over 130 cells. I was about to do the equation for every single cell until this video, very helpful . . .

[Tubigirl]

Absolutely beautifully explained. Excel can be intimidating especially since I have not used it since college many years ago. I needed the information that you just showed in this video to do my job today. Thank you.

[westonlee]

Thank you for your video. I have a question. I’m trying to use the values that are in column D 15 and keep that same value but in sale J 15 I’m taking the value from 15×12 and don’t want to copy that equation through KLMNOP.

[michaeldennis]

is this possible? row A has the quantity example (30) row B has numbers separated by commas, example (2.500, 3.500, 2.450, 5.235) Row C has numbers separated by commas, example (2.500, 3.500, 2.450, 3.650) this is the formula that I have that gives me the totals for both rows in row D. =SUM(VALUE(CELLSPLIT(B2, ", ")))+SUM(VALUE(CELLSPLIT(C2, ", "))).
I would like to that the total in row D and multiply that by the quanitity of row A. I cant find a fix for this other than putting a formula in row E, example (=d2*a2). is there a way to add that multiplication formula to the formula that already exists in row D?
if you can shed some light I would be appreciative. Michael

[kelvinkhoo]

Hi Kelly,
Do you have one formula that I can use to apply for one column(comment) to another column under the same worksheet

[billkeithchannel]

Crap. This doesn't work in Excel 2000.

[billkeithchannel]

Here, let me save you 2 minutes and 15 seconds: on the cell with the formula hover over the bottom right corner to show the cursor + and double click the left mouse button.