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.
0 Comments
Leave a Reply. |