When you need to apply a minor tweak to the document, it should not take long to Lock up columns license. Such a simple activity does not have to demand additional training or running through handbooks to learn it. With the appropriate document editing instrument, you will not spend more time than is needed for such a quick change. Use DocHub to simplify your editing 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 take minutes or so to learn to Lock up columns license. The sole thing required to get more effective with editing is actually a DocHub account.
A plain document editor like DocHub will help you optimize the amount of time you need to spend on document editing regardless of your previous knowledge of such instruments. Create an account now and increase your productivity 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