Locking cells in Excel
Posted on 2014-04-27
I was wondering if one had a row of say 10 cells. Is it possible to set it up so that the person filling out the row would not be able to write into a cell if there were empty cells previously.
So say, they typed the person's name in cell A2, then their phone number in cell B2. Then the person filling out the form tried to enter the street name in D2 before entering the cell phone in C2.
I would really like it if it shocked them with 50 volts, but I am rather sure that is a violation of the Federal Employee Regulations.
As you can probably figure out, I have an employee who doesn't know how or won't fill out an Excel sheet correctly. I suppose this is the last chance before firing them.