WoosoolWoosoolHelp Centre

Protect sheets and ranges

Stop people from changing a sheet or some cells, even if they can edit the spreadsheet.

Web
On this page
  1. Protect a sheet
  2. Protected ranges

Protect a sheet

On the Review tab, choose Protect sheet. Edits on that sheet are refused until protection is removed.

Protected ranges

  1. On the Review tab, choose Protected ranges.
  2. Add a range and a description.
  3. Choose who can edit it: only the owner and the people you list, or anyone after a warning.

Cells others can't edit freely are marked with stripes. A refused edit explains why.

Plan

Protected ranges are available on Pro, Business and Enterprise.