Remove Formula but keep values/data in Excel | Excel Tricks | How To

In this quick tip Excel tutorial we are learning how to remove or delete the formulas in workbook but keep the values or data.
This approach does not require any formula or coding and can be done in seconds if you know how to do it in Excel.
In this video we learnt three different methods to use Paste Special to replace or remove formulas but keep the values or results in cells in swiftest possible manner.
All three techniques are explained in easy to understand manner.
For more free Excel tutorials and resources visit: pakaccountants.com/excel/
Fb: / learnexceltoexcel
Tw: / exceltoexcel
Pin: / pakaccountants
#MsExcel #ExcelTipsandTricks #LearnExcel

[@josemanuelsalgueiro5364]

You can also use CTRL-c, and then CTRL-v, and then CTRL again. Excel shows you some options and if you press V, it paste values and not formula. This option is faster, because you do not need to use the mouse

[@kavithalingesan6325]

Thank you very useful

[@ajayamancha2915]

Hey!! Thanks for the video.

[@uzmaahmad6964]

That's cool specially the last one.

[@melodyinmypoem217]

Perfect! Saved me so much frustration today. I had another problem and couldn't figure out how to add the _ Underscore to a column of data figures, not text: 011 112 130, etc. Took forever to find how to make this column _011 _112 _130 with underscore. I have 2600 rows of text so that would be so much time manually line by line. Same 2600 lines for this underscore column, so I am so thankful to you for your video. I was in tears earlier, as I had to learn for work today using a huge spreadsheet.

[@HasaanFazal]

Happy that it helped :)

[@basantabarik2265]

Wow ! Great

[@prasannakumarmc8304]

Very useful, Thanks

[@satyanveshi36]

Last trick was cool!
thanks for sharing

[@HasaanFazal]

Indeed

[@manishasaklani1280]

Very helpful

[@selvianand8265]

Super thank you

[@tahsildartenali7237]

thank you sir

[@michgee3740]

We used to be able to paste values on a filtered selection, but now the paste goes onto hidden rows rather than just the filtered rows. Do you know a way around this please?

[@Happiness379]

Would you know how to remove the format of the date "12/3/2019" in the formula bar? My column of dates already show a different date format which I would like to show exactly on the formula bar.

[@HasaanFazal]

What I understood is that you want to have the same format for dates in formula bar as you have in the cell. This is possible only by changing the global setting in windows. Number formatting only affects the contents of the cell as actual date and its formatting remains the same that shows up in the formula bar.

[@TheBismila1]

I did it but it didn't remove the formula on my excel, I copy and paste the column of numbers or amounts into a new excel but still have the pivot table formula, how can I get ready of those decimals on amounts, also I highlighted the whole column and choose dollar sign and two decimals but still have the pivot table formula with all those decimals on amounts and I had 3 penny difference on total, and I need to match with another list to the penny

[@HemantSingh-vt2wv]

But when we change the any one value budget or actual ,it's not change the ans

[@lawrencehanson8552]

👍👍👍👍

[@amyraizaty3552]

How to have formula back after we remove it?

[@donshelton9103]

Once you convert formulas to Values, how can you go back showing formulas?

[@HasaanFazal]

I'm afraid that is not possible or at least not in my knowledge yet.

[@ConsulthinkProgrammer]

Permit to answer. You can hide the formula and in the same time just show the value in google sheets.