If you want to apply a small tweak to the document, it must not take long to Place formula permit. This sort of basic action does not have to require extra education or running through handbooks to understand it. Using the right document editing instrument, you will not spend more time than is necessary for such a swift change. Use DocHub to simplify your editing process whether you are a skilled user or if it’s your first time making use of an online editor service. This tool will take minutes to figure out how to Place formula permit. The sole thing needed to get more effective with editing is actually a DocHub account.
A plain document editor like DocHub can help you optimize the time you need to devote to document editing irrespective of your previous knowledge about this kind of resources. Create an account now and boost your productivity instantly with DocHub!
in this video i will show you how to lock cells in microsoft excel i prepared a table here and as you can see i have the values 2 and 5 and later on in the cell b4 i have a formula which calculates the sum of these values now i want to lock the workbook so that the user can only edit the values in the orange fields and that this sum is still being calculated and also that the user cannot see the formula behind this field b4 so to achieve this we first highlight all the cells that we want the user to be able to edit later on then we go to the home tab into the alignment section and click on this little arrow in the bottom right corner now we go to the protection tab and remove the check mark where it says locked then we click on ok and go to the file tab and here in the info section we click on protect workbook and then on protect current sheet now we can enter a password and if we would now lock the sheet the user would only be able to edit these orange fields but he would also be abl