I have an excel sheet on Excel 2013 that I lock down in all but one cell. The idea being a person comes into the sheet, and can paste into into that one cell only and the sheet will auto populate.
The problem is there is ONE MORE cell that should be locking with the rest of the sheet but it will not lock. The result is that the entire sheet is locked but two cells. When someone pastes into the appropriate cell and hits enter, it jumps to the bottom of the sheet where the other unlocked cell is and this ends up getting overwritten on the next paste causing many problems.
Why cant I get that one cell to lock? What could I be missing? It's driving me crazy!!
Please help,
Les
Bookmarks