To unlock a cell, you can go to the Format Cells dialog box (Home:Cells:Format Cells) and under the Protection tab, you can lock and unlock cells.
Personally, I do a lot of locking and unlocking, so I have a Lock Cell toggle button on my Quick Access Toolbar. To do that,
* Right click on the toolbar and select "Customize Quick Access Toolbar".
* Under "Choose Commands from", select "Home Tab".
* Scroll down to "Lock Cell", and double click it. Voila!
Now you have to lock the sheet. You do this with Review:Protect Sheet. There are lots of options for what can be done with a protected sheet, but you can just hit OK until you figure out what's best for you. I usually do not password protect. You can unlock the spreadsheet the same way.
Again, I do a lot of this so I have a Lock Sheet toggle on my QAT. Same general procedure except the command is under the Review tab.
|