When you want to apply a minor tweak to the document, it must not take long to Lock up spreadsheet notice. Such a simple action does not have to demand additional training or running through manuals to understand it. With the right document modifying tool, you will not take more time than is necessary for such a swift edit. Use DocHub to simplify your modifying process regardless if you are an experienced user or if it’s your first time making use of an online editor service. This tool will take minutes to figure out how to Lock up spreadsheet notice. The only thing needed to get more productive with editing is a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to dedicate to document modifying regardless of your prior knowledge of such tools. Make an account now and boost 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