Excel 2013: Trying to lock all but a few cells on a worksheet. Some text cells will not lock. Is there a bug? or is there a more advanced formatting or setting i need to use? thank you!
Note that I: 1) locked the entire worksheet (format cells/protection/click "lock") 2) then went to Review/Protect Worksheet, and entered a password 3) tested. Numerical cells were protected, as designed; SOME text cells were not locked. SOME were protected properly.
Try right click > Format Cells > Protection > Locked
Hidden and Locked both have functionality here. Recall that you must Protect Sheets in addition to protecting a workbook.