How can we help you?

In MyOffice Spreadsheet you can protect the following elements:

Sheet: Users cannot edit all or protected cells of the sheet.

Document structure: Users cannot add, delete, move, rename, duplicate, hide sheets or display hidden sheets.

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:

In the Command menu, select Data > Manage Protection > Protect Sheet.

Right-click the sheet tab and execute the Protect Sheet context menu command.

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

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 side_panel_search_close.

On the Sidebar, click side_panel_protection Manage Protection.

When working with a file in Microsoft Excel and LibreOffice Calc applications, sheet protection settings are not applied to cells located outside the workspace.

Protect the document structure

To protect the document structure, follow these steps:

1.Open the Manage Protection pane. To do this, in the Command menu, select Data > Manage Protection > Protect the document structure.

2.On the Spreadsheet Structure tab:

If necessary, set a password to remove protection from the document structure.

Click Protect Structure.

3.Close the Manage Protection pane in one of the following ways:

At the top of the pane, click side_panel_search_close.

On the Sidebar, click side_panel_protection Manage Protection.

Unprotect a sheet

If the sheet is protected from editing, the following icon is displayed on the sheet tab: sheet_tabs_protection. To remove the protection, you may need to enter a password.

To remove the protection from the sheet, follow these steps:

1.Click on the sheet tab with the mouse.

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

In the Command menu, select Data > Manage Protection > Unprotect Sheet.

Right-click the sheet tab and execute the context menu command Unprotect Sheet.

3.In the Sheet tab:

If the sheet is password protected, enter the password and click Unprotect Sheet.

If the sheet is not password protected, click Unprotect Sheet.

4.To close the Manage Protection pane, do one of the following:

At the top of the pane, click side_panel_search_close.

On the Sidebar, click side_panel_protection Manage Protection.

Unprotect sheet structure

If the document structure is protected from editing, the sheet_tabs_protection icon is displayed to the right of the sheet tabs To remove the protection, you may need to enter a password.

To unprotect the sheet structure, follow these steps:

1.Open the Manage Protection pane. To do so, in the Command menu, select Data > Unprotect Spreadsheet Structure.

2.On the Spreadsheet Structure tab:

If the document structure is password protected, enter the password and click Unprotect Sheet.

If the document structure is not password protected, click Unprotect Sheet.

3.To close the Manage Protection pane, do one of the following:

At the top of the pane, click side_panel_search_close.

On the Sidebar, click side_panel_protection Manage Protection.

Was this helpful?
Yes
No