Lock cels in formula excel for mac

broken image

When the Format Cells window appears, select the Protection tab. Right-click and then select 'Format Cells' from the popup menu. Next, select the cell(s) that you wish to protect.

broken image

Right-click on then select 'Format Cells' from the popup menu. To do this, select all of the rows and columns in your sheet.

broken image
broken image

Question: How do I protect a cell from being edited by others in Microsoft Excel 2011 for Mac?Īnswer: First, you'll need to un-protect all of the cells on your sheet.