Protecting a Single Cell in Excel
September 05, 2004 - by Bill Jelen
Reader Greg McFarland sent in a cool suggestion. Another reader had asked if it is possible to protect a single cell in an Excel worksheet without protecting the whole worksheet. In general, this is not possible.
However, Greg provides an interesting workaround that will keep most people from changing the cell.
- Click in the cell
- From the menu, select Data
- Then select Validation
- In the validation box are various options. Use the settings: Allow Date, between 01/01/01 and 01/01/01.
- Click OK to close the Validation box
If anyone tries to type anything other than 01/01/01 in the cell, they will receive a message saying the value that they entered is not valid.
Since doing this I never have people typing in cells on shared documents and they don’t really know enough to go to the data – validation tab to figure it out. It isn’t complete fool proof, but it works great for me.
The usual caveats: Setting up data validation does not prevent someone from using copy and then pasting an incorrect value in the cell. Also, if your spreadsheet users know the validation technique, they can override your setting. However for most novice users, this should work fairly well. Thanks to Greg for sharing the tip!