Apply Formula to Multiple Cells in Excel | Use the Same Formula in Entire Column, Row or Table

In this video, I demonstrate how to apply a formula to multiple cells in an Excel worksheet. For example, you may want to apply the formula to an entire column, row or table.

I look at four methods:
1) Using the fill handle
2) Using shortcut keys CTRL ENTER, CTRL D and CTRL R
3) Using Excel Tables
4) Using dynamic array formulas (only available in Excel 365)
------------------------

[robr]

This has to have saved me at LEAST a whole day of trying to do it manually, bless you

[farahshaaban]

As many have expressed, thank you for taking the time to share these guiding tips. I required multiple cells spread-out across a spreadsheet to calculate a value based on an adjacent cell, and that of a 'fixed' cell. The preceding '$' anchoring technique for both column- & row-designator of the 'fixed' cell in a formula was exactly what was required to mitigate me having to manually enter the formula in each cell due to natural migration of the formula when copied & pasted. Cheers Chester!

[RK-epqy]

Thank you! Literally got the answer in the first few seconds

[chinyererachel]

Thank you, it was super useful especially Ctrl+D

[carlleewai]

Thanks Chester, this was so easy and painless, i used <>"" at the end to very good effect. this was by far easier that most the others. Thanks again. will subscribe!

[khashayarmodaberi]

Thank You So Much!!! Really Thank You Sir!😊😊🙏🙏

[annakernohan]

Thank you so much! You're a lifesaver

[IvanCortinas_ES]

Thank you for these shortcuts. They are very useful Chester!!!

[-saisarvarayudu]

Nice explanation and simply superb
Thankyou chester

[aimanjavid]

thank you very much, Jiza ka Allah khair

[Dauti_]

What I was looking for when Google led me to this video is this: I already have a table with values calculated by various other different formulas. I want to round up all these values to the nearest whole number, so I want to add the roundup function to every cell in the table and have the roundup function nest inside of it whatever is already in each of the cells.

[foxfirerage]

Anyone know how to stop the reference from skipping numbers when pasting into every other cell? I am using =IF(NAMELIST!$D1="", "", NAMELIST!$D1) but in row three it uses D3 then 5
then 7. I just want to skip rows but count normally D1 D2 D3. Any ideas?

[alamzeb]

If you want to apply a same formula on value in column sale 2021 what is the method...

[GarthVader]

Thanks Chester, how would I run a formula down several hundred thousand rows?

[mwizanyirenda]

What is the financial function that allows you to apply a formula to multiple rows, same as dragging down. Please help 🙏🏾

[cursion]

How do I do that first one on mobile version?

[omernozi]

how can i copy formula if the formula is sumproduct? i can't copy it for rows

[firozsidify]

Figures in Balance Sheet are supposed to be in thousands.. and the data are in different cells.. now how to do it in thousands ??? Plz tell