Search results
Results from the WOW.Com Content Network
Add a password to protect your entire workbook and control whether others can open or make changes to it. Protect your file by setting passwords for Open and Modify.
How to protect an Excel file using a password to prevent unwanted access to your data.
You can protect the Excel file by specifying two passwords: one to open, and the other to modify. You can later share the appropriate passwords with the team depending on the access they should be given.
Note: To further restrict reviewers from making changes to your document or spreadsheet, you can make the file read-only or you can password protect it. For more information, see Restrict changes to files and Make a document read-only.
For password access, in the Range password box, type a password that allows access to the range. Specifying a password is optional when you plan to use access permissions. Using a password allows you to see user credentials of any authorized person who edits the range.
To help improve your privacy in Excel, a password adds protection to worksheets to help prevent others from changing, moving, or deleting important data.
Before you enabled password protection, you can unlock some cells in the workbook. Once you are done with your changes, you can lock these cells. Follow these steps to lock cells in a worksheet:
If your organization uses Microsoft Purview Information Protection, they probably want you to apply that same protection to any PDFs you create from Microsoft 365 files. Here's how to do it using a Windows PC.
If possible, remove password encryption from the file. To do that, go to the Review tab. If Protect Workbook is highlighted, click it to turn off protection. Enter the password if prompted.
To help protect your computer, files from these potentially unsafe locations are opened as read only or in Protected View. By using Protected View, you can read a file, see its contents and enable editing while reducing the risks.