- #HOW TO LOCK CERTAIN CELLS IN EXCEL MAC 2011 HOW TO#
- #HOW TO LOCK CERTAIN CELLS IN EXCEL MAC 2011 PASSWORD#
It is also interesting that if you are working with a document where there is sensitive information, you can lock all the document's cells and then unlock only those that can be modified without the risk of changing the final result. The operation can be undone, but it has to be done by the user who did it in the first place. It is also locked to prevent users who do not have permission to work on a document from rewriting data. Click on OK to apply the changes: Checkbox to lock cellsĪgain, locking a cell means that it is impossible to modify what is written in the cell it is not possible to rewrite or change attributes of the cell, such as formatting.Ĭell locking can be useful in situations where you are working with a large amount of sensitive data, where changing a number or a character by mistake can ruin a huge amount of working hours by changing the final result, and therefore, its interpretation.
In this tab, select the Locked check box so that the contents of the selected cells cannot be altered. Now when you scroll down, you should still continue to see the column headings. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu. So if you have a sheet that you want to share and allow other users to only edit certain cells, you’ll need to use different tables. Select the Layout tab from the toolbar at the top of the screen. While Excel gives you the option to lock specific cells or a range of cells, Numbers isn’t currently this flexible. To freeze the top row, open your Excel spreadsheet.
#HOW TO LOCK CERTAIN CELLS IN EXCEL MAC 2011 PASSWORD#
If you want to unlock other cells, you’ll need to select Review > Unprotect Sheet from the ribbon bar and provide the password (if used) to remove worksheet protection.There, go to the Protection tab: Location of the Protection tab NOTE: Freezing panes only works when you are in Normal View. Once you’ve saved your changes, only the cells you’ve unlocked (if you’ve unlocked any) will allow changes.
#HOW TO LOCK CERTAIN CELLS IN EXCEL MAC 2011 HOW TO#
How to Remove Worksheet Protection in Excel You’ll need to remove the worksheet protection if you wish to make any changes to locked cells afterwards. However, locking cells has no effect until you protect the worksheet. Once you’ve locked your worksheet, any attempts to make changes to locked cells will result in an error message. You can lock cells in Excel if you want to protect cells from being edited. Type the password you provided into the “Confirm Password” box and press “OK” to confirm. If you decided to use a password to protect your sheet, you’ll need to confirm your changes using it. When you’re ready, make sure that the “Protect Worksheet and Contents of Locked Cells” checkbox is enabled, then press “OK” to save your changes and lock the worksheet. For example, if you want to allow a user to delete a row containing locked cells, enable the “Delete Rows” checkbox. If you want to change this, select one of the checkboxes in the section below. Type a password into the text boxes provided if you want to do this.īy default, Excel will allow users to select locked cells, but no other changes to the cells (including formatting changes) are permitted. In the pop-up menu, you can provide a password to restrict changes to the sheet you’re locking, although this is optional. From the ribbon bar, select Review > Protect Sheet. To enable worksheet protection, open your Excel workbook and select the worksheet you want to restrict. How to Enable Worksheet Protection in Excel Excel will block any attempt to make changes to other cells in your worksheet with this protection enabled, which you can activate by following the steps below. Only cells with the “Locked” setting removed will accept changes once worksheet protection is activated. Any other cells will, by default, block any changes once worksheet protection is activated. With the “Locked” setting removed, the cells you’ve selected will accept changes when you’ve locked your worksheet. Uncheck the “Locked” checkbox to allow changes to those cells once you’ve protected your worksheet, then press “OK” to save your choice. In the “Format Cells” menu, select the “Protection” tab. Right-click the selected cells and select “Format Cells” from the pop-up menu to proceed. You can select individual cells or select a larger range of cells. Once you’ve selected the worksheet, you’ll need to identify the cells you want to allow users to modify once your worksheet is locked down.