lkpli.blogg.se

In other words, you may want to only lock a cell or range that shouldn't be changed. Instead, you can lock only specific cells, columns or rows, and leave all other cells unlocked.įor example, you can allow your users to input and edit the source data, but protect cells with formulas that calculate that data. However, in some cases you may not want to go that far and lock the entire sheet. In last week's tutorial, you learned how to protect Excel sheets to prevent accidental or deliberate changes in the sheet contents. And finally, you will learn how to detect and highlight locked and unlocked cells in Excel. It also shows how to unlock individual cells on a protected sheet by a password, or allow specific users to edit those cells without password. Type a password, if you want one, and then click OK.The tutorial explains how to lock a cell or certain cells in Excel to protect them from deleting, overwriting or editing. On the Tools menu, point to Protection, and then click Protect Sheet. Click to select the Locked check box, and then click OK. On the Format menu, click Cells, and then click the Protection tab. To select nonadjacent (noncontiguous) cells, hold down CTRL and click the cells that you want to protect. Select the cells that you want to protect.

Click to clear the Locked check box and click OK. Select the entire worksheet by clicking the Select All button (the gray rectangle in the upper-left corner of the worksheet where the row 1 and column A headings meet), or by pressing CTRL+A or CTRL+SHIFT+SPACEBAR. Secondly, If you Want the Majority of Cells to be Unlocked, follow these steps: The cells you needed to lock will be locked. Type a password if you want one, and then click OK.

On the Format menu, click Cells, and then click the Protection tab.Ĭlick to clear the Locked check box and click OK. To select nonadjacent (noncontiguous) cells, hold down CTRL and click the cells that are to remain unprotected. Select the cells that you want to remain unprotected. If You Want the Majority of Cells Locked then follow these simple steps: The procedure to use depends on whether you want the majority of the cells on the worksheet to remain locked or unlocked. This article describes how to lock individual cells in a Microsoft Excel worksheet. You can remove the protection from a worksheet as needed. To prevent a user from accidentally or deliberately changing, moving, or deleting important data from cells of your worksheet or workbook, you can protect certain worksheet or workbook elements, with or without a password.