Click on the Protect button and select Protect Sheet from the popup menu. Option #1: If your Excel window is narrow, you should see a Protect button in the Protection group. Then depending on the size of your Excel window, Microsoft changes the menu options so there are two options for the next step, depending on the width of your Excel window. To do this, select the Review tab from the toolbar at the top of the screen. Click the OK button.įor the locking of the cells to take effect, you must also protect the worksheet. 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. Right-click on then select "Format Cells" from the popup menu. To do this, select all of the rows and columns in your sheet. ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |