How to restrict access to sheets in Excel office365?

Question

excel

The Excel file contains multiple sheets.
It is necessary to be able to configure - which of the users should have access to which sheet. Mode - "Read only" with access to formulas.

Answer 1

Selective protection of ranges
If several users work with a file, and each must change only
their area of ​​the sheet or different sheets, then you can make selective protection of ranges with a unique password that
applies to different ranges of cells.
This type of protection implies that all protected
cells have the Protected cell (Locked) attribute set.
To install such protection, you need to:
1. On the Review tab, in the Changes group, select
Allow Users to Edit Ranges:
2. In the window that appears, click the New button.
Enter the Name (Title) of the protected range.
Select Protected Cells (Refers to cells).
Enter the Range password to access the cells.
OK:
Repeat step 2 for different ranges.
3. Enable protection for a sheet or multiple sheets by clicking the Protect Sheet button.
Now, when you try to access any of the protected ranges, the program will
require you to enter a password for this particular range:
To remove protection, just on the Review tab, in the Changes group
, select Unprotect Sheet.