Allow editing specific ranges within a protected spreadsheet

You can protect specific worksheets so that other users cannot modify, move, or delete important data accidentally or intentionally.


To protect a sheet

  1. Click File or Review > Protection > Allow to Edit Ranges.
  2. Click the New button in the Allow to Edit Ranges dialog box.
  3. Specify the title, cell range, and the range password.
  4. Click OK and then again the same password in the Confirm Password and then click OK.
  5. Click OK in the Allow to Edit Ranges dialog box to close the dialog box and unlock the range.
    You can keep making some changes such as title and cell range while opening the Allow to Edit Ranges dialog box by clicking the Apply buttion instead of the OK button
Was this article helpful?
0 out of 0 found this helpful