Set read-only and modify passwords for Excel2007 data files

Source: Internet
Author: User

Our lives and jobs often have data in Excel documents that need to be kept secret, so we can set a read-only password or modify the password for the Excel tabular data document.

Let's take a look at how to set a password for a document in Excel2007.

Click the button in the upper-left corner of the Excel2007 and select Save As in the pop-up menu. or press the shortcut key F12 is also the same effect.

In the lower left corner of the Save as interface, there is a tool button, click the small triangle to the right of the Tools button, and select General Options in the pop-up menu.

Computer Tutorials

Then we can set the password in the General options.

You can use this password to read this Excel file after you set the password to open permission.

You can use this password to open and modify this Excel file after you set the password to modify permissions.

When you check "recommended Read Only", others pop up the suggested read-only prompt when they try to open an Excel file.

Setting a password for a file in the Excel2000 and Excel2003 versions is similar, but the interface is slightly different, as shown in the "Save As" interface "tool" is in the upper-right corner.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.