#Lock a cell in excel for mac password

#Lock a cell in excel for mac password

In the window that opens, make sure there is a check mark next to the item Protect spreadsheet and locked cell contentwrite the password you want to use to protect the spreadsheet in the text field click the button good and go back to write the password to apply the changes. Then select the tab review the program (top right) and click the button Protect the blade. la, B, 1, 2 ) or scattered individual cells in the spreadsheet using the join Ctrl + click ( Cmd + click en Mac)įinally, you must protect your spreadsheet with a password using the special function of Excel. You can select entire columns or rows from the spreadsheet using the appropriate side indicators (eg. When done, select all the cells in the spreadsheet by clicking the ◢ button in the upper left corner (enter la and 1 ), I went to the card casa Excel and unlock all cells in spreadsheet by selecting item Lock cell of menu format.Īt this point all you have to do is select the cells you want to lock and select the option again Lock cell of menu format Excel (always on the tab casa of the program). As it is easy to understand, this step is necessary only if the document to be modified is protected with a password.

Open the spreadsheet you want to protect, select the tab review Excel (top right) click the button Remove sheet protection and enter the password to unlock the file and make it editable.