Protecting ranges

The Protect Range option allows you to specify cell ranges that cannot be edited by users without corresponding editing rights that are granted by the creator of the file or a user with full access to it.

WARNING The Protect Range feature is not supported by third-party editors, so the protected information will become compromised if opened via third-party software.

To select a range of locked cells, a user will be allowed to change:

1. Click the Protect Range button on the top toolbar of the Protection tab. The Protected Ranges window will open.

   

2. Use the Filter drop-down list to choose the required sheet. Click the New button in the Protected Ranges window to select and add a range of cells a user will be allowed to edit.
3. In the New Range window, type the range Title, and select the range of cells by clicking the Select Range button. Select users who can edit this range and click OK to confirm.

   

4. To edit or delete a range, select it in the Protected Ranges window and click the Edit or Delete button accordingly.
5. Click the Close button in the Protected Ranges window when you are ready.

To learn more about allowing edit ranges, please refer to the following article.