XL: How to Lock Individual Cells in a Worksheet

Summary

This article describes how to lock individual cells in a Microsoft Excel worksheet. The procedure to use depends on whether you want the majority of the cells on the worksheet to remain locked or unlocked.

NOTE: If you lock a cell and protect the worksheet, then you cannot type data into the cell, modify the data currently in the cell, or change other attributes of the cell (such as cell formatting).

More Information

To unlock individual cells in an Excel worksheet, use either of the following procedures.

If You Want the Majority of Cells Locked

To lock the majority of the cells on the worksheet, follow these steps:

  1. Select the cells that you want to remain unprotected. To select nonadjacent (noncontiguous) cells, hold down CTRL and click the cells that are to remain unprotected.
  2. On Excel show the format cells dialog box by clicking the Expand button to the bottom right of the Font section of the Home ribbon, and then click Protection tab.
  3. Click to clear the Locked check box and click OK.
  4. In Excel click the Review tab, and click Protect Sheet. Type a password if you want one, and then click OK.

If You Want the Majority of Cells Unlocked

To leave the majority of the cells on the worksheet unlocked, follow these steps:

  1. 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.
  2. Excel show the format cells dialog box by clicking the Expand button to the bottom right of the Font section of the Home ribbon, and then click Protection tab. Click to clear the Locked check box and click OK.
  3. Select the cells that you want to protect. To select nonadjacent (noncontiguous) cells, hold down CTRL and click the cells that you want to protect.
  4. Return to the Format Cells dialog box, and then click the Protection tab. Click to select the Locked check box, and then click OK.
  5. In Excel click the Review tab, and click Protect Sheet. Type a password, if you want one, and then click OK.

References

For additional information on Cell Protection see the following links:


Lock or unlock specific areas of a protected worksheet

Lock cells to protect them in Excel 2016 for Mac



Özellikler

Makale No: 214081 - Son İnceleme: 21 Kas 2016 - Düzeltme: 1

Microsoft Excel 2010, Microsoft Excel 2013, Excel 2016, Excel for Mac for Office 365

Geri bildirim