How to set read-only and change password for data in Excel2007

In our daily life and work, data in some Excel documents must be kept confidential. In this case, we can set a read-only password or change the password for the Excel table data document.

Next, let's take a look at how to set a password for the document in Excel2007.

In Excel2007, click the button in the upper left corner and select "save as" in the pop-up menu ". Or press the shortcut key F12.

In the lower-left corner of the "save as" interface, there is a "tool" button. Click the small triangle on the right of the "tool" button and select "general options" in the pop-up menu ".

Then we can set the password in "general options. After the "open permission password" is set, others can use this password to read the Excel file. After setting "change permission password", others can use this password to open and modify the Excel file. When "read-only is recommended" is selected, when others try to open an Excel file, a prompt window indicating read-only is displayed.

PS: setting passwords for files in Excel2000 and Excel2003 is similar, but the interface is slightly different. In the "save as" interface, "tools" are in the upper right corner.