mirror of
https://github.com/ONLYOFFICE/web-apps.git
synced 2026-07-24 23:17:58 +08:00
105 lines
5.6 KiB
HTML
105 lines
5.6 KiB
HTML
<!DOCTYPE html>
|
||
<html>
|
||
<head>
|
||
<title>Protecting a sheet</title>
|
||
<meta charset="utf-8" />
|
||
<meta name="description" content="Protecting sheets 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>Protecting a sheet</h1>
|
||
<p>The <b>Protect Sheet</b> option allows you to protect the sheets and to control changes made by other users in a sheet as to prevent the unwanted changes to data and to restrict the editing abilities of other users. You can protect a sheet with or without a password. If you don’t use a password, anyone can unprotect the protected sheet.</p>
|
||
<h3>Protect a sheet</h3>
|
||
<ol>
|
||
<li>
|
||
Go to the <b>Protection</b> tab, and click the <b>Protect Sheet</b> button on the top toolbar.<br />
|
||
or<br />
|
||
right-click the sheet tab you want to protect, and select <b>Protect</b> from the list of options
|
||
<p><img alt="Protect Sheet Tab" src="../images/protect_sheettab.png" /></p>
|
||
<p class="note">Alternatively, go to the <b>Home</b> tab → click the <b>Format</b> button → <b>Protect sheet</b>.</p>
|
||
</li>
|
||
<li>
|
||
In the <b>Protect sheet</b> window that opens, enter and confirm the password, if you want to set a password to unprotect this sheet.
|
||
<p><img alt="Protect Sheet" src="../images/protect_sheet.png" /></p>
|
||
<p class="note">The password cannot be restored if you lose or forget it. Please keep it in a safe place.</p>
|
||
</li>
|
||
<li>
|
||
Check the boxes in the <b>Allow all users of this sheet to</b> list to select operations that users will be able to perform. The operations <b>Select locked cells</b> and <b>Select unlocked cells</b> are allowed by default.
|
||
<details class="details-example">
|
||
<summary>Operations a user may be allowed to perform.</summary>
|
||
<ul>
|
||
<li>Select locked cells</li>
|
||
<li>Select unlocked cells</li>
|
||
<li>Format cells</li>
|
||
<li>Format columns</li>
|
||
<li>Format rows</li>
|
||
<li>Insert columns</li>
|
||
<li>Insert rows</li>
|
||
<li>Insert hyperlink</li>
|
||
<li>Delete columns</li>
|
||
<li>Delete rows</li>
|
||
<li>Sort</li>
|
||
<li>Use Autofilter</li>
|
||
<li>Use PivotTable and PivotChart</li>
|
||
<li>Edit objects</li>
|
||
<li>Edit scenarios</li>
|
||
</ul>
|
||
</details>
|
||
<p class="notehelp">Please note that when a sheet is protected, no user can sort or filter data within. For filtering to carry out properly, the filtering parameters shall be applied prior to protecting a sheet.</p>
|
||
</li>
|
||
<li>
|
||
click the <b>Protect</b> button to enable the protection. The <b>Protect Sheet</b> button on the top toolbar stays highlighted once the sheet is protected.
|
||
<p><img alt="Protect Sheet Highlighted" src="../images/protectsheet_highlighted.png" /></p>
|
||
</li>
|
||
</ol>
|
||
|
||
<h3>Allow edit ranges</h3>
|
||
<ol>
|
||
<li>Click the <b>Protect Sheet</b> button on the top toolbar of the <b>Protection</b> tab. The <b>Protect sheet</b> window will open.</li>
|
||
<li>Click the <b>Allow edit ranges</b> button to specify ranges unlocked by the password when the sheet is protected. This option works for locked cells only.</li>
|
||
<li>
|
||
Click the <b>New</b> button to add a new range. The <b>New range</b> window will be opened. Specify the <b>Title</b> of the range, the range itself, and enter and repeat a password. Click <b>OK</b> when ready.
|
||
<p class="note">The password cannot be restored if you lose or forget it. Please keep it in a safe place.</p>
|
||
</li>
|
||
<li>
|
||
When a sheet is not protected, you can still make changes to the allowed ranges:
|
||
<ul>
|
||
<li>If you need to edit a created range, select it in the <b>Allow users to edit ranges</b> window and click the <b>Edit</b> button.</li>
|
||
<li>To delete a created range, select it in the <b>Allow users to edit ranges</b> window and click the <b>Delete</b> button.</li>
|
||
</ul>
|
||
</li>
|
||
<li>Click the <b>Protect</b> button when ready.</li>
|
||
</ol>
|
||
<p>For ranges protected with a password, when someone tries to edit the selected range of cells, the <b>Unlock Range</b> window appears, where the user is prompted to enter the password.</p>
|
||
<p><img alt="Unlock Range" src="../images/unlockrange.png" /></p>
|
||
<p>To learn more about protecting ranges, please refer to the <a href="../UsageInstructions/ProtectRanges.htm" onclick="onhyperlinkclick(this)">following article</a>.</p>
|
||
|
||
<h3>Unprotect a sheet</h3>
|
||
<ol>
|
||
<li>
|
||
To unprotect the sheet:
|
||
<ul>
|
||
<li>
|
||
click the <b>Protect Sheet</b> button, <br />
|
||
or<br />
|
||
right-click the protected sheet tab and select <b>Unprotect</b> from the list of options
|
||
<p><img alt="Unprotect Sheet Tab" src="../images/unprotect_sheettab.png" /></p>
|
||
<p class="note">Alternatively, go to the <b>Home</b> tab → click the <b>Format</b> button → <b>Unrotect sheet</b>.</p>
|
||
</li>
|
||
<li>
|
||
enter a password and click <b>OK</b> in the <b>Unprotect Sheet</b> window if prompted.
|
||
<p><img alt="Unrotect Sheet" src="../images/unprotect_sheet.png" /></p>
|
||
</li>
|
||
</ul>
|
||
</ol>
|
||
</div>
|
||
</body>
|
||
</html> |