View Single Post
Old 06-10-2014, 03:28 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

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.
Reply With Quote