Add Incentive Plan Signature Block with airSlate SignNow

Protect bulletin

in this video we're gonna talk about how to lock individual cells and also how to protect the worksheet you can create a password and protect it so first let's put some data on the worksheet let's zoom in first let's call this the first quarter and this will be the second quarter or rather let's just call it q1 let's see if we can extend it so we have the first four quarters and here in the first column we're gonna put the name of ourselves agent let's say John Salley Megan Ronald and let's say Rachel and then we're gonna take the sum and average now let's put some random numbers so let's type in equal Iran between and I want the cells for each quarter to be somewhere between 10,000 and a hundred thousand so first I need to select the bottom number and then comma and then the top number so let's extend it and also let's extend it to the right okay so I have some random numbers and let's go ahead and format these cells so let's right click go to format cells and then number and let's turn it into a currency with no decimal places now let's take the sum of the cells for the five cells agents now these numbers will vary because I'm using the randbetween function so as you can see they're being updated and that was taken which now all of the cells that I don't want anyone to edit basically the cells that I want to lock I'm gonna put a color to it so I don't want anyone to edit my headers so let's give that a color you don't have to give this color it's not necessary but I'm just doing it so let's give it a blue color and then I don't want anyone to edit the names of these individuals so let's give that another color let's choose like a lighter color and my sum and average these formulas I don't want it to be edited so let's put another color to that let's make it yellow and also the word summon average I don't want to have to change either so let's give that a red background color so the only things that I want someone to be able to edit are the cells in each quarter for these five cells agents now what you need to do at this point is you need to go to let's right-click this if you go to format cells and then go to protection at the top notice that the cells are locked and you what you're gonna have to do is you can have to protect the worksheet but before we protect it we need to unlock certain cells so every cell in this excel worksheet is locked so once we protected the worksheet we won't be able to edit anything so what we need to do is unlock the cells that we want...