How to Lock and Protect Cells in Excel | Scribe

    How to Lock and Protect Cells in Excel

    • |
    • 24 steps |
    • 2 minutes
      1
      Click "Select All"
      2
      Right Click on any selected cell, for example, "F8".
      3
      Click "Format Cells..."
      4
      Click "Protection"
      5
      Click "Locked" to uncheck it.
      6
      Click "OK"
      7
      Click "Name Box"
      8
      Type "f13:f23 [[enter]]"
      9
      Right Click on any cell within the selected range, for e.g. "F16".
      10
      Click "Format Cells..."
      11
      Click "Locked" to check it.
      12
      Click "OK".
      13
      Right Click on the Worksheet Tab, for e.g. "Qn16"
      14
      Click "Protect Sheet..."
      15
      Click in "Password to unprotect sheet" window and type the password.
      16
      Type in the given password, "noedit".
      17
      Click "OK"
      18
      In the "Reenter password to proceed." window, retype the password.
      19
      Type "noedit" and press "[[Enter]]"
      20
      Click "A15"