Protect a sheet

You can protect all or selected cells on the sheet from changes in the workspace. By default, MyOffice Spreadsheet protects all cells.

To protect the contents of a sheet, follow these steps:

1.Click the sheet tab with the mouse.

2.Open the Manage protection pane in one of the following ways:

•On the Protection tab, click Protect sheet.

•Right-click the sheet tab and run the Protect sheet context menu command.

•When working in macOS, you can also run the Data > Manage protection > Protect sheet command from the command menu.

3.If you want to protect all cells of the workspace, do not clear the Locked for changes checkbox.

4.If you need to specify the cells that users will be able to edit after installing protecting the sheet:

•Select these cells.

•Uncheck the Locked for changes box.

5.If you want users to see only the result of the formula calculation in the protected cells and in the Formula bar:

•Select these cells.

•Check the Formulas not displayed box.

6.Expand the Allowed actions section and specify what actions users are allowed to perform with protected cells.

7.If you need to set a password to remove protection from the sheet, expand the section Password (optional), enter the password and confirm it.

8.Click Protect sheet.

9.Close the Manage protection pane in one of the following ways:

•At the top of the pane, click .

•On the Sidebar, click Manage protection.