Files
svetlana maleeva b2bea7513f Update help
2025-10-23 18:14:13 +03:00

39 lines
2.7 KiB
HTML

<!DOCTYPE html>
<html>
<head>
<title>Protect ranges</title>
<meta charset="utf-8" />
<meta name="description" content="Protecting ranges to prevent the unwanted changes and to restrict the editing abilities of other users" />
<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
<script type="text/javascript" src="../callback.js"></script>
<script type="text/javascript" src="../../../../../../common/main/resources/help/search/js/page-search.js"></script>
</head>
<body>
<div class="mainpart">
<div class="search-field">
<input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
</div>
<h1>Protect ranges</h1>
<p>The <b>Protect Range</b> 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.</p>
<p class="notehelp">The <b>Protect Range</b> feature is <b>not</b> supported by third-party editors, so the protected information will become compromised if opened via third-party software.</p>
<p>To select a range of locked cells a user will be allowed to change:</p>
<ol>
<li>
Click the <b>Protect Range</b> button on the top toolbar of the <b>Protection</b> tab. The <b>Protected Ranges</b> window will open.
<p><img alt="Edit Ranges" src="../images/editranges.png" /></p>
</li>
<li>Use the <b>Filter</b> drop-down list to choose the required sheet. Click the <b>New</b> button in the <b>Protected Ranges</b> window to select and add a range of cells a user will be allowed to edit.</li>
<li>
In the <b>New Range</b> window, type the range <b>Title</b>, and select the range of cells by clicking the <b>Select Range</b> button. Select users to provide access to the range, set their <a href="https://helpcenter.onlyoffice.com/userguides/groups-guides-documents-share-documents.aspx#step5_block" onclick="onhyperlinkclick(this)">access rights</a>, and click <b>OK</b> to confirm.
<p><img alt="New Range" src="../images/allowedit_newrange.png" /></p>
The available access rights are <b>Edit</b> and <b>View</b>.
</li>
<li>To edit or delete a range, select it in the <b>Protected Ranges</b> window and click the <b>Edit</b> or <b>Delete</b> button accordingly.</li>
<li>Click the <b>Close</b> button in the <b>Protected Ranges</b> window when you are ready.</li>
</ol>
<p>To learn more about allowing users to edit ranges, please refer to the <a href="../UsageInstructions/ProtectSheet.htm" onclick="onhyperlinkclick(this)">following article</a>.</p>
</div>
</body>
</html>