how to make excel read only

原创 admin 2021-01-09 01:02 

This example shows you how to make your workbook read-only. Users can still save changes by creating a new copy of the workbook. For a better protection, protect a sheet.

1. Open a workbook.

2. On the File tab, click Save As.

3. Click Browse.

Click Browse

4. Click on the Tools button and click General Options.

Tools, General Options

5. In the Password to modify box, enter a password and click OK.

Enter a Password

Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don't enter a password and check Read-only recommended.

6. Reenter the password and click on OK.

Reenter the Password

Note: this feature does not encrypt your Excel file. Malicious users can edit the file and remove the password.

7. Enter a file name and click Save.

Click Save

Your workbook is read-only now. The password for the downloadable Excel file is "easy".

版权声明: 本文为4find – 解决程序猿问题原创文章,欢迎转载。转载请务必注明出处! (参考格式:本文转自4find – 解决程序猿问题,原文地址:http://4find.cc/archives/1280

发表评论


表情