Forum Discussion
excel locking issues
Can I lock an excel sheet, but leave 3 cells editable?
- Of course! By default all cells are marked as locked. Unlock the cells you want to grant access to (right-click, Format Cells, Protection tab, uncheck "locked"). Then to invoke locking all cells but the ones you unlocked, you must protect the worksheet (Review, Protect Sheet button)
3 Replies
- Of course! By default all cells are marked as locked. Unlock the cells you want to grant access to (right-click, Format Cells, Protection tab, uncheck "locked"). Then to invoke locking all cells but the ones you unlocked, you must protect the worksheet (Review, Protect Sheet button)
JKPieterse I still can't get only particular cells to lock. It's either the entire worksheet is locked or the entire worksheet is unlocked. I only want to lock 5 formula cells. I want the remainder of the spreadsheet to remain editable. Step by step, how is this accomplished
- By default ALL cells are locked, so you only have to set cells which need to be edited to Unlocked and then protect the worksheet. Select all cells (control+a multiple times until all cells are selected), press control+1 to open the cell formatting dialog, click the Protection tab and UNCHECK Locked. Now select the cells which need to be locked, then control+1 again, this time check that box. Now protect the worksheet and you're good to go.
