Apply a Formula to an Entire Column in Excel

Two Ways to Apply a Formula to an Entire Column in Excel

[@arianavaldovinos3222]

I'm going to be completely honest I was doing each row by hand and basically making so much work because I couldn't do this so thanks a million i would have failed without this

[@NowProcrastinating]

Thanks a ton! I don't know why excel cant make an elegant video like this.

[@yulunghui3957]

Extremely helpful video, short and to the point. Thank you! I'm so glad I found this one, the first few tries for doing this were not anywhere as good.

[@tonymontana897]

Thank you , Thank you, Thank you !!
Finally, someone who explains it so easily and method that actually works and you don't have to guess how you arrived at the answer.
Xu Cui. You are THE MAN !!

[@trefaji]

so simple, but so helpful! this is exactly what i was looking for, thanks.

[@abhishekkharche3469]

"Double click now" this saved me from multiple days frustrations!!! Thanks for explaining the simple solution in a simple way.

[@emmamcintosh9493]

Thanks a million billion! Saved me tearing my hair out.

[@nigh5bot]

The most useful video in RUclips for adding formula in excel for a large dataset. Thanks a lot ❤

[@thenuggetyas]

Oh my gosh, you are so amazing! I knew that there must've been another alternative but other RUclipsrs only suggested using the fill handle. You saved me, and my grades! Thank you!

[@kasha9961]

for excel 2013 this works perfect. it works for me for almost 0.165 million entries in row :)
"Apply formula to an entire column or row with Fill command.
1)Actually there is a Fill command on the Microsoft Excel' Ribbon to help you apply formula to an entire column or row quickly.
2)Enter the formula of =(A1*3+8)/5 in Cell C.Select the Column C.
3)Click the Home > Fill > Down.
If you want to apply the formula to entire row, just select a row, and click Fill > Right."

[@jacksonwit901]

This video changed my life! Bless your soul sir

[@briangutierrez7404]

Thanks so much. Quick informative video. Went straight to the point

[@MotherGosling]

Thank you for refreshing my memory! It's a while since i built a spreadsheet, and this saved me a lot of time.

[@mishmack9367]

So glad i found this!! THANK YOU

[@pranita_chaturvedi]

Thank you so much for saving my time with this! 😊❤

[@sebastianm.6669]

finally, some guy from 10 years ago answers this simple question I've had for months...
thank you

[@ioannamantzoufa8484]

Thank you! I have forgotten this and really need it now !

[@arthurp19]

WOO Funny how simple it could be if you only know! Thank you!!

[@ciloudacunha3858]

You saved my life. Thank you

[@kushalsheth1473]

Thanks,Mr. Xu Cui
Actually i have forgotten this as i am using excel after very long time.
Love From INDIA.

[@turuus5215]

Thank you. You saved from frustration.

[@Evairee]

You are a lifesaver. Thank you, asian man in glasses.

[@akhilgada602]

Asian man? He is a human like us why to divide ourself :).

[@marvininer]

Thank you so much! I've watched a lot of videos before, this trying to copy a formula without a value on the reference cells and this is the only which showed me how to do it.

[@moizamir2025]

thanks bro very very nice video .may your channel grow up.

[@ayazmahmud7239]

thanks a ton...much appreciated
keep up the good work

[@TheVnator]

This is the kind of feature that you can't really understand unless you see it on video. Thanks for showing us!

[@gokusays]

you're the best, i've been wanting to do that in a long time! with 30,000+ rows, this is magic. :)

[@silas3181]

Thanks man! Very helpful and concise

[@jotarokujo312]

Thanks goat this was really helpful.

[@alishahaupt3584]

Thank you for posting this video! It has helped me a lot!!🤗😁

[@newleft2254]

Thanks babes. Didn't know it was so easy!

[@hasnainbashir]

This is a very useful tool. Thanks so much!

[@joshuaeudave1510]

You saved me so much time thank you

[@cmazloomi]

Simply brilliant!!
Thank you for your 'right to the point' style.

[@cameronlegree]

You are a fantastic person!

[@ST-us7kq]

thank you so so so much, you saved the day

[@skiranzhade4366]

Thank you i saved lot of my time by this

[@jayabharat5390]

Thanks . U saved my time

[@sharish1701]

Thank you so much. I was just looking for this only.

[@smidgen2190]

Thank you! You are a life saver.

[@chemnyeimzaw2688]

thanks u guy.I spent over 2 hours and found out nothing.u helped me a lot.

[@mikepalmer2709]

Clear and helpfully explained, many thanks

[@simasima5255]

Comprehensive and simple!! thank you so much

[@paulclarke2321]

Thanks so much Xu Cui - brilliant!

[@toothsieroll6390]

Thank you so much for this tutorial, this is very helpful!

[@trickmasterextra6425]

Amazing 😍 and helpful
Thanks 🙏🙏🙏🙏

[@ListRankSell]

Thank you for this super helpful video.

[@tenderhearted2002]

Exactly what i was looking for. Thanks!

[@MohsinQasmi-rw8ub]

Thanks Xu for sharing your knowledge

[@mitchellwhitten2445]

Thanks so much, you just saved me hours of work!

[@alexandrapepe391]

Thank you! Very helpful

[@KhemistryIBMOR]

Thank you! for the simple solution!
Best Wishes!

[@ChuObii]

Thanks, that was just what I was searching the web for right now. :)

[@nadyahtg3678]

Thank you very much, very very helpful

[@DineshSuthar-wq6ih]

Thanks you so much, your video help me so much

[@abdenourchabane9626]

Thanks a million for this crucial technique

[@magdagonzalez792]

Thank you for the video! Very useful!

[@thisisangellorenzo]

Saved me so much time. Thank you!

[@shubhamshukla86]

Very helpfull and easy explained

[@gregballard7438]

Thanks this really saved me a lot of time!

[@SyedZayanAhmed]

Thats really informative! Thanks

[@TheBugError]

Finally someone answered MY STUPID QUESTION. I had Unknown count of filled rows in a column and I needed to calculate them all no matter if they are empty. But everyone was explaining how to do it for a specific range but no one said I can press CTRL + ENTER to FILL every cell in a column with my specific formula.

[@LitchMingo]

Thanks...just saved me a lot of time!!!

[@sulovelive9279]

Finally, I found this. Thanks a lot.

[@kitchugeths]

Simple and quick...
Thanks mate

[@usamarao1768]

REALY HELPFUL THANKS

[@AmitKumar-jv4mp]

Really helpful, Thank you sir

[@pcchim0805]

Thx a lot, 10s to understand and use it. Well done!!!!

[@shawndurbs]

thanks. you saved me hours of work

[@AustinLWright]

This is so simple. Thank you.

[@loribarnes3271]

This worked perfectly. Thank you!!!

[@markwelbourn3653]

SO helpful... HUGE timesaver... THANK YOU

[@Luciano7126Throwed]

Thank you!!! Exactly what I needed.

[@heihachimishima6713]

Love your voice!!!..............UNIQUE

[@dentmahmoud]

Thank you so much this tip saved me heaps of time

[@vinayaksharma-ys3ip]

Thanks ton for this!!!

[@NeuroPulse]

You are a master. Thank you!

[@The33e33]

Thanks for getting right to the info promoted!!

[@avantikamaurya9424]

Won't be a joke if I say you saved my life

[@chrizziacarino990]

LUCKY I FOUND THIS TUTORIAL..

[@bharadwajpisipati]

thank you for the help!

[@TheClinchMagazine]

Thanks a lot Mr.

[@oneverse111]

I just wanted to say that I love you bro!

[@futuresdojo]

Thank you very much! This has been very helpful!

[@kizhissery]

You saved my day

[@akhilgada602]

Thanks for sharing. Was very useful.

[@lukezacharias3062]

Very Very Very helpful. Thank you!

[@marisacabrera3953]

Thanks a billion!

[@heliahashemi8832]

Thank you so much, that helped a lot.

[@95U99]

thnq so much, it helped me alot

[@hotamtoy5287]

Thank YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@user-wb1xi1yo8c]

Thank you so much!!!!

[@mydogsayshowl]

Thank you, exactly what I needed!

[@adityasharmaklr]

Thank you brother :) .

[@taha-t2b]

thank you so much!

[@khemraj6155]

Thank you. That helps so much

[@thrydwulf]

Thank you very much! Greatly appreciate it.

[@dipendu02]

finally what I was looking for
thank you so much

[@WayneTheWolf]

Thanks for your help!

[@DanielHamacher]

Thank God I found this video. It ain't fun applying a formula to a 320k row training set by scrolling down :)