contador web Skip to content

How to Password in Excel to Protect Entire Data or Spreadsheets | Productivity

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

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 RibeiroIn the Review tab, click the Protect Sheet button: Photo: Reproduction / Daniel Ribeiro

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 RibeiroIn the setup wizard, check the activities that will be allowed to all users. Photo: Playback / Daniel Ribeiro

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 RibeiroEnter a password, check the change block option and click OK Photo: Playback / Daniel Ribeiro

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 RibeiroBefore activating the protection, confirm the password and press OK Photo: Playback / Daniel Ribeiro

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 RibeiroAny protected changes will be blocked by displaying the highlighted message Photo: Reproduction / Daniel Ribeiro

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.To remove the lock, click Unprotect Spreadsheet on the Review Photo: Reproduction / Daniel Ribeiro 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 RibeiroEnter the password you previously created in Protect Worksheet to unlock issues Photo: Reproduction / Daniel Ribeiro

Enter the password you previously created in Protect Worksheet to unlock issues Photo: Reproduction / Daniel Ribeiro