In both instances, you can protect an Excel workbook with a password to make it read only. This means users will be able to open the workbook and view the data but won’t be able to make any changes to the spreadsheet. This is vitally important if you are running a small to medium-...
Encrypt an Excel file with a password so that it requires a password to open it. To password protect an Excel file, execute the following steps.
Method 1. How to Password Protect an Excel File with Excel’s Built-In function? Warning:Microsoft cannot restore forgotten passwords, so make sure that your password is not easy to forget! Additionally, there are no restrictions on the passwords you use for Excel encryption with regards to le...
Protect a workbook with a password to prevent others from adding, moving, deleting, hiding, or renaming the worksheets in the workbook.Require a password to open an Excel fileSelect File > Info.Select the Protect Workbook box and choose Encrypt with Password....
1. Open the Excel file in normal mode. 2. Select the whole worksheet by clicking the Select All button. 3. On the Review tab, in the Changes group, click Protect Sheet. 4. Make sure "Protect worksheet and contents of locked cells" is checked, type a password. Allow all users of thi...
如何使用EaseUS LockMyFile保護Excel工作表: 步驟1.啟動EaseUS LockMyFile,輸入電子郵件,設定密碼以註冊。 步驟2.點擊檔案保護。在右側選擇保護檔案、資料夾或硬碟。 1. 在特定位置中新增檔案或資料夾。 2. 點擊保護硬碟以新增想要保護的磁碟機。然後點擊該磁碟機並點擊確定。
Part 2: How to Remove Password from Excel Files How if you want to remove the password from the Excel file? Situation 1: You still remember the password. First, enter the password to open the encrypted file; then, go to [Protect Workbook] and remove the password. These steps are similar...
1. Password protect the whole file from viewing.2. Password protect the sheet from editing.3. Password protect excel workbook from changing structure.4. Password protect a single and cell ranges to keep the important data not be changed.
Password Protect at SaveYou can also protect an Excel file while saving it.In the Ribbon, go to File > Save As.In the save window, click More options…In the bottom-right of the Browse window, click Tools and choose General Options…...
Require a password to open an Excel file SelectFile>Info. Select theProtect Workbookbox and chooseEncrypt with Password. Enter a password in thePasswordbox, and then selectOK. Confirm the password in theReenter Passwordbox, and then selectOK. ...