When you need to apply a minor tweak to the document, it should not require much time to Lock columns charter. This type of simple action does not have to demand extra training or running through manuals to learn it. Using the proper document modifying instrument, you will not spend more time than is needed for such a quick change. Use DocHub to streamline your modifying process regardless if you are an experienced user or if it’s the first time making use of an online editor service. This tool will take minutes or so to learn to Lock columns charter. The only thing required to get more effective with editing is a DocHub account.
A plain document editor like DocHub can help you optimize the time you need to dedicate to document modifying irrespective of your prior knowledge of this kind of instruments. Make an account now and increase your efficiency immediately 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