Select all cells (by clicking on the arrow in the upper left corner of the gridlines), (2) right-click anywhere in the selected area, and (3) choose Format Cells….To lock only a specific range of cells (for example, B1:B3), follow these steps: To be able to edit cells again, unprotect the sheet. Now, if you try to edit any cell in the sheet, you’ll get the message that the sheet is protected and can’t be edited. In the pop-up window, confirm the password and press OK.
As you can see, after you protect the worksheet, users will only be able to select cells. In the Protect Sheet window, enter a password and press OK.In the Ribbon, go to Review > Protect Sheet. This means that, when you protect your sheet, all cells are locked for editing. In the Format Cells window, go to the Protection tab, and here you can see that Locked is checked.By default, all cells in Excel have the property Locked turned on, and you can check this (1) by selecting all cells (click the arrow in the upper left corner of the gridlines), (2) right-click anywhere in the selected area, and (3) choose Format Cells….In Excel, you can lock all cells for editing. This tutorial demonstrates how to lock cells in Excel and Google Sheets.
0 kommentar(er)
