If you need to unlock the whole sheet click the little icon, above cell A1, this will select the whole sheet and you can proceed with the remaining steps from here to unlock the cells. Navigate over to where it says “Protections”.Įffectively you have now unlocked the cells and now can have them edited if you need.Step by step process – How to unlock cells in Excel for Mac Follow the step-by-step process below to see how you can unlock cells in Excel for Mac. In this blog, we will be looking at solutions on how to help users unlock cells in Excel for Mac and find possible solutions to help prevent the error from occurring again. However what if you need to change some information or correct formula in a cell, how would you try and fix this error with the cells now locked? Cells, cell ranges, rows, and columns can all be locked. Unlike Numbers, Microsoft Excel allows you to lock cells in a variety of methods. On the other side, you could have data that you don’t want to modify unintentionally while you’re working on the sheet. Maybe you just want them to be able to modify particular cells. If you have a spreadsheet or workbook in Excel that you want to share with others, you probably have data that you don’t want them to modify.
