People often need to conceal guide in excel when managing documents. Unfortunately, few applications offer the tools you need to complete this task. To do something like this typically requires alternating between a couple of software applications, which take time and effort. Fortunately, there is a platform that suits almost any job: DocHub.
DocHub is a professionally-built PDF editor with a complete set of useful features in one place. Altering, approving, and sharing documents becomes simple with our online tool, which you can access from any internet-connected device.
By following these five easy steps, you'll have your modified excel quickly. The intuitive interface makes the process fast and efficient - stopping switching between windows. Try DocHub today!
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 able
