Remove Formula but keep the data in Excel (2 Really Simple Ways)

Have formulas that you want to remove but keep the data as is? In this video, I will show you two super simple methods to remove the formula but keep the data.
The first method is by using Paste Special. You just need to copy the existing cells - which have the formulas that you want to remove - and replace these with values only. This can easily be done using the Paste Special dialog box.
Another method to do this is by using a less-known mouse trick. Select a range of cell, place the cursor at the right edge of the selection, hold the right mouse key and move it a little to the right and then bring it back. This will show you a menu that will have the option to 'copy and paste as values'.
This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@raheemuddin7689]

I was watching this on my office laptop. I am so satisfied that I came on my phone to like this video and comment since i am not logged in on my laptop. Thank You Bhai

[@trumpexcel]

Thank you so much for the kind words... Glad you found the videos helpful 🙂

[@celinepalmer118]

I honestly can't thank you enough. I am doing a thesis and have so much data to go through and had this issue. Couldn't figure out how to do it and no web links or videos were helping me until I came across this. Thanks for keeping it so concise. You are a lifesaver !

[@marvinjoventuryasingura2179]

Brooooooooooo. May God bless you, your family and your whole entire generation. May you become very rich too. Thank you.

[@englishbulldoglover2258]

You made it quick and easy with your explanation and demonstration. Thank you!

[@ScottNazarian]

This guy is by Far and Away THE BEST EXCEL Guru on the Web...nobody is even a close 2nd.

[@ErnestOzz99]

I use this works really well too. Select the data -> copy -> right click -> in paste options select the board with 123

[@goldengolden2451]

Fantastic illustration on how to remove the formulas from excel!.

[@decoimage7051]

thank you sooo much!!! I was looking for it in many diffrent languages half of the night. Thank you for a million!

[@trumpexcel]

Glad the video helped 🙂

[@wayneedmondson1065]

Hi Sumit.. thanks for the video. Love that right click drag right and left tip. Many people don't know that one. Thanks and Thumbs up!

[@claudiamarcogliese361]

Thank you for the quick and simple help!

[@jakubkolodziejczak1950]

Great and easy explanation! Straight to the point! Thank you so much.

[@user-vd3ro3fi3l]

Thank u so much!!!! No description i typed and searched gave me this!! Much appreciated

[@DavidJimenez-wv7gh]

thanks bro, you save me! I hope India can reach the moon with it's chandrayaan moon mision, the world is proud of you guys

[@DeonBlackwell]

When someone helps me with a software question, I give them a like. Thanks for the helpful video.

[@rajugoud1563]

Super bro i save lot of time by watching this video

[@naveedshaikh8408]

Brilliant! love the way you show multiple ways to do it. One of the way worked while the others did'nt.

[@fxprocc]

the best video i have seen for this feature. straight to point and with little crafty hints that was not ever aware existed. thank you sir

[@leslieray8174]

Thank you for this! I was struggling with how to get rid of a formula, and this did the trick!

[@845karolewithak]

Thank you, thank you, thank you. Great job. So simple, and explained very well.

[@accountshyderabad4856]

its really nice, saves much time while working on it without strees

[@Iffy50]

Thank you! I was able to use this information in about 10 seconds!

[@GeorgianaMedeleanu]

Very easy! Thanks a lot

[@sueredfern9620]

So simple and so well delivered thanks :-)

[@BybChanelBibene]

Thank you. So helpful, saved me from troubles.

[@everynews8848]

Superb. Relevant guidance without any tome delay

[@suryakumar-dl7pt]

THANKS. BAHUT DINO SE PARESHAN THA MAI

[@abhisheksamantray5244]

after watch this video, I subscribed, sir

[@3DUnlocked]

Thank you so much saved more precious time,love from India.👍

[@travellingwithkundan1505]

Thank,i have used your ideas

[@miselacha]

Brilliant! Thank you!

[@krishnakumar-pc5lu]

Hi sumit tried the first option real cool and nice voice modulation

[@mohanshekar6261]

Quick way to know solutions for my problem, thank u so much 😊

[@jno8482]

quick and to the point, perfect tutorial, thanks Sumit!

[@jayavardhanp280]

Really this helped thanks so much even chatgpt didn't give this exact resolution

[@mrCetus]

Hi Sumit.. thanks for the video. Love that right click drag right and left tip. Many people don't know that one. Thanks and Thumbs up!

[@mohanadali5049]

Thank you so much bro

[@tanial568]

Awesome demonstration, your instructions were clear and concise.

[@sohamsaha5370]

Excellent... Thanks a lot..

[@trumpexcel]

Glad you found the video useful 🙂

[@sandeeprath1874]

Man you're an absolute genius.

[@brightorb1]

thank you so much saved me ton of time

[@Sunflower_729]

thank you so much sir you saved my lots of time 👍👍

[@adriennecarlson5857]

Thank you so much. I've wanted to know how to do that for years!

[@samsam7673]

Thanks so very much. it saved my time

[@sharudinsalleh4891]

Thanks a lot for your videos man. You're a great teacher

[@chetansethi4366]

Thanku so much bhai.

[@theitspossibleguy]

thank you, this saved me a ton of time

[@yaseenpasha2996]

Thank you ! You save my 30 min time . Thank you

[@AlexanderMoen]

so simple and I had forgotten about this, and have been having trouble. Thank you for the quick and relevant video.

[@kevinjohnson484]

WORKS! Thank you!

[@ethelndlovu1853]

Thank you

[@melodiousthepoeticpoint5332]

Thankyou very much, it was very useful to me

[@DPB1947]

Brilliant, thank you!

[@murugesanmurugesan3726]

Thanks i learnt remove the formula and keep the data .nice

[@tarasairanatashaneil]

Thanks - you made this very easy

[@ashavarghese1088]

Thankyou for knowledge sharing. Simple methods.

[@whitenoise3415]

Thanks a lot

[@vrdsp1]

Thank you brother, you really saved my day 😀💙💙

[@trumpexcel]

Glad the video helped 🙂

[@dabsmoothbeats1174]

Excellent!! Thank you!

[@ianfosterUSA]

brilliant thanks from the uk

[@shivaveluru3088]

Good explanation thank you

[@rhyshughes6374]

You absolute legend. Thanks!

[@Tony_Duhh_Tiger]

This video saved me so much time! Thank you so much!

[@Education-Lover-9]

THANKS, A LOT YOU RESOLVED A BIG PROBLEM.

[@yoloyouonlyliveonce2480]

Thanks 👍

[@whoknows7901]

Thank you for this.

[@priyadarshiniojha2705]

Thank you for this.

[@cosasverdes]

THANK YOU

[@trumpexcel]

Glad you found the video useful!

[@Chemist-t7w]

nice its really good thank you

[@asfiyahpeah8304]

thank you very muchhh. simple and fast

[@dj.anderson]

Exactly what I needed!

[@kunalkhune3635]

Excellent it helps me lot to solve my problem with excel

[@emurtaza]

this small thing was literally a lot of help.

[@VikasKumar-hc9qo]

Thanks for these video

[@marvindacullo1659]

Big help. Thank you bro

[@dragondiego7]

Thank you, help's a lot!

[@vimalraj1822]

Excellent info

[@abdurrasheedmohmand2983]

Thanks more than a lot bro. You really nailed it

[@sarahmwale1092]

Thank you,this has really helped me today

[@livingonthenorthshoremande4279]

THANK YOU!

[@marcosresto544]

Thank you. This was most helpful

[@shafqatzaidi4876]

Thanks for the video. I learnt and made it. Thanks again.

[@umakanth1982]

Thank you so much. This helped me a lot.

[@JayMac95]

Thank you!

[@AishHumairaa]

Thank you so much !

[@sefacakr]

OMG THATS CRAZY HOW CAN I HAVE NEVER THOUGHT OF IT !

[@lordcharfield4529]

Thank you so much!

[@chettri77]

was very helpful thanks

[@ranjitpatil3958]

Thank you for helping me

[@SantosChronicles]

Thank you. You are a life saver.

[@spaceshantynow1851]

Thank you so much!

[@vikasdhanai4900]

Thank you so much sumit

[@sonorangaming449]

Thank you!

[@aln9251]

well explained thanks.

[@premsewnarain9882]

Very good

[@fang_shi_tong]

Excellent! Super clear. Thank you!

[@lalan.yadav.1012]

U are amazing 👏 💖

[@alinsharma8819]

Thank you for great knowledge

[@eatpraylove4918]

thank you so much brother

[@nirmalmaharjan737]

A lot of thanks mate

[@dmuralidhar4680]

Sir your 2nd tip to remove formula is amazing and a new thank you so much Sir