Apply Formula to an Entire Column in Excel (5 Easy Ways)

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course

[@gaganwadhwafreelancer]

sir i want to ask you one thing.
is there any shortcut key combination to fill the formula in Upper one cell .
as Ctrl + D to fill formula down.

[@ushasi91]

🎉

[@beacher7169]

Thank you, Sumit. Still helping people 3 years later!

[@trumpexcel]

Glad it's helpful 🙂

[@dtruthteller]

Simply breathtaking! Granted, I haven't watched too many Excel videos but, of the ones that I have watched, this is BY FAR the most impactful. I'm torn between 3 of these methods as to which one I'm going to use more. THANK YOU!

[@stephaniewhite9526]

I have been selling using Excel CSV uploads for ages but never knew how to change a whole column. Textbooks have always made it look so hard but this video is so amazingly simple and perfectly explained and I had it completed instantly. Surely the best tutorial of its kind.

[@komalacharekar]

Thank you so much, I had more than 80k records to apply formula for, that double click idea saved hell of of time for me🙌

[@patrickschardt7724]

I always learn things here that I don’t see in other Excel channels often. Great stuff

[@trumpexcel]

Thanks for the kind words Patrick... Glad you found the video useful!

[@dimple7267]

Thank you.. SO helpful.. Google search should put this on top. Thanks again. People nowadays say so garbage words unnecessarily. Yours was just to the point.

[@nadyaal-attas2528]

Intelligence in its simplest form. Thanks a lot!

[@sumitchauhan3732]

This saved my day. Small tips but very useful .

[@rowshanfatema5928]

After a long time. Good to see again.
I want to be good at Excel like you.

[@justinpapin6397]

Great guide, accurate and straight to the point. RUclips is forcing us to use the comments to validate good content now smh.

[@vikramjitsinghsawhney7721]

Good job Sumit I leant a few things ..thanks buddy

[@samerhakimi4463]

Dear Mr, sumit, this samir from Afghanistan i would like to thank you for such a fruitful lecture.

[@adhithiyanb1823]

thank you so much for this information this is very helpful for my work

[@joebrandtmusic]

Fantastic!! Such a time saver!! Thank you!!

[@lionofjudaheternal8918]

Thank you for Creating this video

[@lisamilam4443]

Perfect. Just what I needed!

[@rashidobaid3837]

thank you soo much, it helped me with my quantitative analysis course

[@salmaalaa6158]

welcome back master .its nice to see and learn from you after long time . happy return back

[@er.pravinkadam1117]

VERY ICELY EXPALINED THANK YOU AND KEEP IT ON.....................................................

[@vijaykishan8649]

After a long back with a refreshing session. Good one.

[@trumpexcel]

Thanks Vijay :) Glad you like found it useful

[@jadecolbert4286]

Thank you!!! Sometimes the drag approach copies the same exact sum. Thank you for showing the correct approach when that happens. This saved me a lot of time. Bravo!

[@mohammedhammouda2692]

very helpful. Thanks!

[@maheshm4519]

thanks sir, u saved my time

[@adeniyiadebayo2584]

Great video .. really helpful thanks.

[@IvanCortinas_ES]

Hello again Sir. Nice to see you back here again. Thank you.

[@cogwheelLearning]

Really useful stuff! I did not know about the CTRL + enter shortcut!

[@wmfield152]

Good tricks to allow you to keep your hands on the keyboard instead of always reaching for the mouse--makes the process smoother. Thanks again Sumit.

[@user-cn9vv6er5e]

Thanks a lot! Very usefl shortcut !

[@Patrick-ge2zn]

Didn't know the first one , click on the green square , will use this a lot , many thanks .

[@trumpexcel]

Glad you found the video useful!

[@jerine1516]

Thank you for sharing Sir. Love it very much.

[@sharyujamodkar4673]

thank you! thank you! thank you!

[@SomniaRomantica]

Thank you heaps for this!! So to the point and useful, exactly what I needed during doing my taxes :D

[@navitabhatt5290]

Unbelievable.... Very helpful n easy to understand

[@lexoos3544]

Thank you so much! :)

[@greentail]

I'm going to try #2 and #3 tomorrow. Thank you!

[@jmx7656]

Omg...thank you so much.

[@maheshhegde7002]

Super so simple.....super guidance

[@thannerulavanya4117]

Gud demonstration.. I understood this very easily.

[@defaulterrock5780]

Thank you sir help me a lot 😭
Saved my time 😁

[@alkathorat2593]

U r a very good teacher

[@thakurpramodsingh8961]

Thank-you Boss.

[@lionofjudaheternal8918]

Good Video Very useful to me

[@nexsusninja9343]

Thank You brother

[@upendrarahuldubey3261]

Thanks for the Sharing Sir

[@unclet5112]

Thank you!!

[@post11tracy1]

Thank you, Thank you!! Between your video and a few other ones, it took me hours to figure this out! I needed =SUM(E4*15%)+E4 then for the next column =SUM(E4*11%)+E4, then I highlighted the column, CTRL D..CTRL D saved my life tonight!!! LOL!

[@spencercohen1463]

Very helpful, thank you!

[@GoncaloFS]

After dragging a formula manualy 20000 cells down two of three times, i did a search and found this video...
I was literally shocked for a couple of secounds with the "double click on the square method" 😂😂😂
thanks a lot

[@MareeTeolanafo]

A great start for the New Year! Thanks for sharing this.

[@pgsibilo]

Thanks alot, very useful tutorial 👍

[@dureshahwarmisbah8779]

Thank you.

[@Arup20090401]

All good hints.
And then there is one where you convert the range to a table and then apply the formula. This will copy the formula to entire column.
I also like to use name ranges in my formulas whick make them easy to understand and debug.

[@trumpexcel]

Converting to Table is a great option. Makes it a lot easier

[@ogunrinuadesina9756]

@@trumpexcelGreat job. Many thanks

[@Saeed-ru8gf]

Well explained

[@angalieprashani9660]

Thank you so much 🥺💜

[@ronnaniel9276]

Very helpful

[@haikalnajib9037]

thanks man really helpful!

[@cookerymagic2167]

thank you! :)

[@official360news]

thank you so much

[@marv1887]

That was really helpful thank you 🙏

[@ILikeTrains324]

OH MY GOD THANK YOU

[@netsainemberi3071]

thanks for sharing the tricks very useful

[@trumpexcel]

Glad you found the video useful

[@punitvakil3496]

Thank you

[@fayazmuhammad5983]

Sir finally you are comeback.sir do have plan to start power bi toturials.

[@trumpexcel]

I might make some videos on it later in the year. I haven't used Power BI much, so want to spend some time learning it

[@fayazmuhammad5983]

@@trumpexcel Thank you sir

[@mariamzarif1656]

Thank you so much!! Truly helped me. Subscribed and liked 🙏❤️

[@farhadhossainmondalmechani3666]

Awsm brother, tnq

[@ryanechelberger225]

ty so much

[@Junckook24]

Hi
It's worth to subscribe the channel really as the way you present is understandable.
I go through many of your useful videos particularly the dashboards where just want to add that VBA codes should be done as well.
Many regards

[@gattusaitejaswireddy]

I have to do 8000 cells and 24 files...u saved my life bro🤩

[@sureshpolapally2976]

i made it thax bro

[@ulhas10]

Fantastic

[@TheCCCAAAZZZ]

Thanks

[@Yakoop22]

I love you.

[@giyas3882]

Thank u sir

[@malekbasheer6207]

Good video

[@sachind307]

Thanks sir

[@dynamicdivinereadings6520]

Nice video

[@amoghverma3108]

You saved my life from wasting hours on calculation.

[@hassinasaifi5011]

wow it really works:)))))

[@prashanthattikote2028]

You rocks bro 🔥🔥🔥🔥

[@vikrambalaji4126]

god bless you DAMN

[@tariqulislam6291]

Nice too

[@shanoobolavanna]

very very usefull

[@balubalaji9956]

thank u

[@gorakhanathk5054]

After a long time sir?🙏

[@trumpexcel]

Yeah, wasn't posting videos in the past few weeks. Back to regular weekly posting now :)

[@negussietsegaye116]

how can entire row of sheet be multiplied by the same cell of another sheet (ex. colomn A in sheet 2 * B3 in sheet 1.)

[@wayneedmondson1065]

Hi Sumit. Nice tutorial. Thanks for sharing your tips. Looking forward to more in 2021 :)) Thumbs up!!

[@trumpexcel]

Thanks for commenting Wayne... Good to see you again in the comments section :)

[@cefmeadmin4353]

Hi Thank you for the video. Can you please tell me how to get the same formula automatically if I inserted a new row in between the rows or in the bottom. Please help me

[@saikrishnapagadala7449]

Thats a great video! And my favourite is combination of fill handle, ctrl enter and ctrl D :). I use them interchangeably. Actually I heard from peers that excel fill handle or ctrl D, updates the data in the unfiltered range when working on filtered data. Hence they use the combination of select visible rows (Alt ;) and Ctrl enter or ctrl D. But in my view all these shortcuts work irrespective of the sequence of rows (filtered or unfiltered range). Is that correct?

[@amitgurav8495]

Is there any way to pull all pivots from to mail body

[@yamahabalu]

Thank You. How to copy only 2 digits from A1 to paste A5? (A1 has five digits (12345), The column A5 shall be 12. I have 14000 rows. Only first 2 digits from A1 to A5. Please guide.

[@satvikbansal8420]

please tell how to add a new row with formulas of previous row automatically if previous row is filed

[@bashtechs6452]

How will you make a fixed formular in a particular cell for example a1*a2 and it'll auto multiple ones you enter values in both of them without having to type anything again

[@CristinaFunclara]

Is there some way I can copy and paste a formula to an entire column(for example just paste to the entire column B) without filling the first cell from the top which is the header for the column?

[@lucaspaivanannicini]

Can you do the same if you have a reference cell?

[@daywalker3735]

so I am trying to apply an equation to an entire column that pulls data from one cell and applies that to a series of another cells....but I'm a bit stuck lol

[@theturnup300]

Is it possible to multiply a row of numbers by the same number with VBA? So for instance if the constant mulplier is 7 and I enter 5 in the cell should compute 35 in the cell.

[@_randomstation]

How to do calculation for 2 columns

[@nirmalankur]

If the result of the formula is in the first column of another sheet then how do we auto spill till end of the data range?

[@leecannon7001]

Anyone know how to get difference between 2 cells in a column, then the difference between the next column and the second one in first cell and down the column like that.