Excel allows you to "lock" spreadsheets and set authorizations so that collaborators can perform only specific actions on the document. The feature password protects the entire spreadsheet, including both the column and row structure and the contents of each cell. Activities such as deleting and adding rows and columns are prevented by the tool, which requires a code to perform edits. Learn in the following tutorial how to enable the Excel function and protect spreadsheets.
How to add data to Excel from a photo
How to watermark Microsoft Excel spreadsheets
Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo
Step 1. Go to the Review tab in Excel, and press the "Protect Spreadsheet" option;
In the Review tab, click the Protect Sheet button: Photo: Reproduction / Daniel Ribeiro
Step 2. In the Protect Spreadsheet "window, the widget wizard displays a list of options that can be allowed to all users. Select the check box for the activities that will be allowed;
In the setup wizard, check the activities that will be allowed to all users. Photo: Playback / Daniel Ribeiro
Step 3. Then create a password to protect your spreadsheet and select the Protect spreadsheet and locked cell contents "checkbox. Then confirm the setting on the OK button;
Enter a password, check the change block option and click OK Photo: Playback / Daniel Ribeiro
Step 4. Confirm the password created in the window that opens next, and activate the lock on the OK button;
Before activating the protection, confirm the password and press OK Photo: Playback / Daniel Ribeiro
Step 5. Whenever an unauthorized activity is done, Microsoft Excel will display an alert and require password unlocking to make selections or changes.
Any protected changes will be blocked by displaying the highlighted message Photo: Reproduction / Daniel Ribeiro
How to unlock a spreadsheet
Step 1. To remove password protection, simply select the feature button on the "Review" tab;
To remove the lock, click Unprotect Spreadsheet on the Review Photo: Reproduction / Daniel Ribeiro tab.
Step 2. Enter the password previously created during the Protect Spreadsheet activation process to remove the activity lock and allow any unauthorized changes.
Enter the password you previously created in Protect Worksheet to unlock issues Photo: Reproduction / Daniel Ribeiro