Excel 2013 & 2010: How to Lock or Unlock Cells

Are you unable to modify cells because they are locked? Here’s how to lock or unlock cells in Microsoft Excel 2013 and 2010.

  1. Select the cells you wish to modify.
  2. Choose the “Home” tab.
  3. In the “Cells” area, select “Format” > “Format Cells“.
    Excel Format Cells option
  4. Select the “Protection” tab.
    Excel locked setting
  5. Uncheck the box for “Locked” to unlock the cells. Check the box to lock them. Select “OK“. As the dialog box says, locking cells or hiding formulas has no effect until you protect the worksheet. You can do so under the “Review” tab by selecting “Protect Sheet“.
    Excel protect sheet

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>