Mac excel file locked for editing mac os#
Now you will head back to the same menu by selecting “Format” and clicking the option “Protect Sheet,” instead of “Lock Cell”. Have you locked a file with read only permissions and now want to edit it Follow the steps given in this video to unlock a file to allow edit in Mac OS X. Next, go back to the main screen of your document and highlight the rest of your spreadsheet by pressing “Ctrl and A” at the same time. You will notice that every other cell in your document has a highlighted lock symbol, if you select another cell and go back into this menu. I am using Excel 2010 on Win 7 and it seems that many users have the same problem.
Remember that after clicking the “Lock Cell” option to double-check that the lock icon is not highlighted. After researching many articles online, I am stumped and hope someone can help figure this out. From the drop-down menu that appears, click on the “Lock Cell” option when prompted. You will begin by selecting the cell you want to leave unprotected (allowing others to edit and change the cell as they see fit).Īfter you have selected your cell, you will see the “Format” tab at the top of your screen in the Home ribbon. Whether it’s a major project at work or a simple group assignment with your fellow students, you simply need to edit and share a document. Sometimes you can’t avoid the process of group editing.
You can also get started right away by following along on your own document. Editing Cells of Locked Pages in Excel: StepsĪ sample document is provided for you at the bottom of this page. Read the guide below to learn how more about editing cells of locked page sin Excel. This method is perfect for keeping certain data or even just complicated functions that you absolutely do not want to enter a second time locked. This way, you can share a file with the peace of mind of knowing that only certain cells can be changed by members of your team. You can accomplish this by unlocking specific cells in your document. You want to edit certain cells of a shared file, but you also want to keep most of the information locked, so no one accidently edits or deletes anything important. You’ve probably encountered this problem before.
0 kommentar(er)
