While sharing your data with others, the data may be deliberately deleted, changed, or manipulated in any other way. Thus, protecting your work is essential so critical data is not misused while forwarding the file.
Regarding data protection, an entire workbook, single or multiple sheets, and even cells can be protected in Excel.
While protecting a worksheet, you can allow or disallow certain rights to the users. It includes Formatting, deleting, editing, inserting, adding cells/columns/rows, inserting or deleting hyperlinks, using pivot tables, using sort and filter options etc.
Here are five steps to protect a worksheet in Excel.
Select the sheet that you want to protect.
Right-click and select the option to protect the sheet.
Select the checkbox to allow user rights.
Enter the password.
Re-enter the same password again and press OK.
Now, anytime you want to switch to this sheet while working on this particular workbook, a password is supposed to be entered.
The options that can be selected allow the following rights to the users.
Select locked cells: After checking the box for this, users can select the locked cells by default.
Select unlocked cells: In this situation, users are not allowed to work on the cells that have been locked.
Sort/filter: Sorting and filtering of data is an important function. Users can be allowed or prohibited from sorting and filtering the data.
Format Rows/ Columns: In this option, the users can format the rows and columns by changing or adjusting their height, width, etc.
Insert columns/rows: The user can insert rows or columns.
Delete rows/columns: This permits the user to delete rows or columns.
Format cells: Users can change the format of the cells. Also, the conditional formatting rules pre-exist and are applied to the changed data in cells.
Editing Objects: Changes to graphics, charts, adding notes, the users can perform all these functions.
Protecting a sheet or a workbook becomes essential when you have important information that can change the entire reporting, affecting all if changed. You can also lock the cells to prohibit users from changing that particular cell—or close the workbook as a whole so that the user only with the credentials can access the workbook. Use the above five steps to protect the sheet in an Excel workbook and save your sheets.
Komentar