If you want to apply a small tweak to the document, it must not require much time to Protect columns settlement. This type of simple activity does not have to demand extra training or running through handbooks to learn it. With the right document modifying resource, you will not take more time than is needed for such a quick change. Use DocHub to simplify your modifying process whether you are a skilled user or if it’s the first time making use of an online editor service. This instrument will take minutes to figure out how to Protect columns settlement. The sole thing required to get more effective with editing is actually a DocHub profile.
A plain document editor like DocHub will help you optimize the time you need to spend on document modifying regardless of your prior knowledge about this kind of tools. Create an account now and increase your efficiency instantly with DocHub!
in this video were going to talk about how to lock individual cells and also how to protect the worksheet you can create a password and protect it so first lets put some data on the worksheet lets zoom in first lets call this the first quarter and this will be the second quarter or rather lets just call it q1 and lets see if we can extend it so we have the first four quarters and here in the first column were going to put the name of our sales agent lets say john sally megan ronald and lets say rachel and were going to take the sum and the average now lets put some random numbers so lets type in equal ran between and i want the cells for each quarter to be somewhere between ten thousand and a hundred thousand so first i need to select the bottom number and then comma and then the top number so lets extend it and also lets extend it to the right okay so i have some random numbers and lets go ahead and format these cells so lets right click go to format cells and then nu