![translation](https://cdn.durumis.com/common/trans.png)
This is an AI translated post.
What if there are two password unlocks in an Excel file?
- Writing language: Korean
- •
-
Base country: All countries
- •
- Information Technology
Select Language
Summarized by durumis AI
- Excel has two types of passwords: read password and write password. This article explains how to set and unlock them.
- The read password can be set through [File] > [Info] > [Protect Workbook] > [Password Setting], while the write password can be set through [Add Options] > [Tools] > [General Options] when you "Save As".
- Since the write password is not a security feature and is not encrypted, when unlocking the password, you can simply clear all the values entered in the password field and press OK.
Hello.
Today I'm going to tell you about setting an Excel password.
Excel has two types of passwords: read password and write password. If both passwords are set, you will be asked to enter the read password when you open the file, and then another screen will appear as shown above. So how do you set and remove the two passwords?
How to set/remove the read password
If you set it through [File] > [Info] > [Protect Workbook] > [Password], you only set the read password.
To remove it, simply go to the same path, set it up, and save the file.
How to set the write password
The write password can be set when you "Save As". In the screen above, click the green text [More Options] below the filename and file type. Then the following popup will open.
When the popup opens, you can set both passwords by selecting [Tools] > [General Options] in the lower right corner.
By the way, you can set only the write password without the read password.
However, a warning message will appear when you set it up. It says that the write password is not a security feature and is not encrypted. To remove the password, clear all the values entered in the password field, click OK, and save the file.
I hope this helps. If it helped, I would really appreciate it if you could click on the ad once.