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

preview_player
Показать описание
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

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial
Рекомендации по теме
Комментарии
Автор

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 !

celinepalmer
Автор

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

marvinjoventuryasingura
Автор

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

englishbulldoglover
Автор

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

raheemuddin
Автор

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

goldengolden
Автор

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!

wayneedmondson
Автор

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

jakubkolodziejczak
Автор

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

decoimage
Автор

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

ScottNazarian
Автор

Thank you for the quick and simple help!

claudiamarcogliese
Автор

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

vdrofil
Автор

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

ErnestOzz
Автор

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

fxprocc
Автор

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

naveedshaikh
Автор

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

DeonBlackwell
Автор

So simple and so well delivered thanks :-)

sueredfern
Автор

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

karolewithak
Автор

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

leslieray
Автор

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

jno
Автор

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

AlexanderMoen