When you want to apply a small tweak to the document, it must not take long to Delete formula paper. This sort of basic action does not have to require additional education or running through manuals to understand it. With the appropriate document modifying instrument, you will not spend more time than is needed for such a quick edit. Use DocHub to streamline your modifying process regardless if you are an experienced user or if it is the first time using a web-based editor service. This instrument will require minutes to learn to Delete formula paper. The sole thing needed to get more effective with editing is actually a DocHub account.
A simple document editor like DocHub can help you optimize the time you need to dedicate to document modifying regardless of your prior knowledge of this kind of resources. Create an account now and improve your efficiency immediately 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