When you want to apply a minor tweak to the document, it must not take long to Delete formula resolution. This sort of basic action does not have to demand extra education or running through handbooks to understand it. Using the appropriate document modifying instrument, you will not spend more time than is necessary for such a swift edit. Use DocHub to simplify your modifying process regardless if you are a skilled user or if it is the first time making use of an online editor service. This instrument will require minutes to figure out how to Delete formula resolution. The only thing needed to get more effective with editing is a DocHub profile.
A simple document editor like DocHub can help you optimize the time you need to devote to document modifying regardless of your prior experience with such resources. Create an account now and boost your productivity 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