When you want to apply a small tweak to the document, it must not require much time to Regulate formula permit. This type of simple activity does not have to require additional education or running through manuals to understand it. With the right document editing instrument, you will not spend more time than is needed for such a quick change. Use DocHub to streamline your editing process regardless if you are an experienced user or if it’s the first time using a web-based editor service. This instrument will take minutes or so to learn how to Regulate formula permit. The only thing required to get more effective with editing is a DocHub profile.
A plain document editor like DocHub will help you optimize the time you need to devote to document editing regardless of your previous knowledge about this kind of instruments. Make 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