When you need to apply a small tweak to the document, it must not require much time to Lock columns text. This kind of basic activity does not have to demand extra education or running through manuals to learn it. With the appropriate document modifying resource, you will not take more time than is needed for such a swift change. Use DocHub to streamline your modifying process regardless if you are a skilled user or if it’s the first time making use of an online editor service. This instrument will require minutes to learn how to Lock columns text. The sole thing needed to get more productive with editing is a DocHub account.
A simple document editor like DocHub will help you optimize the amount of time you need to dedicate to document modifying irrespective of your prior knowledge about this kind of instruments. Make 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