When you want to apply a minor tweak to the document, it should not take long to Delete formula attestation. This kind of basic action does not have to demand extra education or running through guides to learn it. Using the proper document editing tool, you will not take more time than is necessary for such a swift edit. Use DocHub to simplify your editing process regardless if you are a skilled user or if it is the first time using a web-based editor service. This instrument will take minutes to learn how to Delete formula attestation. The only thing needed to get more effective with editing is actually a DocHub account.
A simple document editor like DocHub will help you optimize the amount of time you need to dedicate to document editing no matter your prior knowledge about such tools. Make an account now and improve your efficiency instantly with DocHub!
hello and welcome to this excel tips video Im so mad pencil and in this video Im going to show you how to quickly remove the formulas from Excel but keep the data so here I have the data for these companies I have the revenue number expense and I have the net income value which is calculated by subtracting expense from revenue if you have a look at the formula it is this L minus this and thats the same case for all these now what I want to do is remove the formula but still keep the net income value and its really easy you simply select this entire data set you copy this then right click and go to paste special and here in the paste special dialog box you have the value option as soon as you click on value and click OK it is going to paste the values only and the formula would go away so now when I click OK see what happens now when I select this cell you can see that the formula bar only shows the value and not the formula because the formula has gone let me also show you another