您可能从某人那里获得了一个Excel文件,但由于奇怪(Excel)的只读(Read-only)通知,您无法对其进行编辑。有几种方法可以解决这个问题,并且像往常一样,我们将稍后讨论它。只读非常常见,意味着用户只能读取文件而不能对其进行任何更改。
如何从Microsoft Excel(Microsoft Excel)中删除只读
如果您希望编辑或更改Excel文档,您可以通过以下任一方法删除只读属性:
- 使用“仍然编辑”按钮
- 保存文件
- 只读推荐和密码锁
- 受保护的床单。
1]无论如何编辑
典型的只读错误只需要用户单击一个显示Edit Anyway (Edit Anywa)y的按钮。完成后,用户现在将能够以他们认为合适的任何方式对文档进行更改。非常直截了当。虽然这可能不会一直有效,但这是您应该尝试的第一件事。如果受密码保护,这可能不起作用 -
2]保存文件
好的,所以修复只读问题的下一个方法是保存文件。单击上面的保存(Save)按钮将不起作用,因此,我们必须利用另存为(Save As)功能。在您的Excel文档中,选择File,然后从那里单击Save As。
选择您想要保存Excel文档的位置,就是这样,您就完成了。继续打开新保存的Excel文档,您应该能够编辑和进行任何更改。
如果您收到错误提示The Excel File Is Restricted ,这也有效。只需按照步骤操作,您就可以开始了。
3]只读推荐和密码锁定
如果您处于整个文档被锁定并且需要密码才能解锁的情况,那么这可能会对您有所帮助。如果在打开Excel(Excel)文档时建议只读,这也将起作用,因此请继续阅读。
好的,所以您需要在这里做的第一件事是,单击File,然后单击Save As。之后,单击More Options,然后从出现的窗口中,在下面查找Tools。
选择它,您应该立即看到添加密码以打开文件或取消选中只读框的选项。
4]保护表
可以保护Microsoft Excel中的工作表。我们可以通过右键单击工作表名称来执行此操作,然后选择保护工作表(Protect Sheet)并确保添加密码。受保护的工作表意味着没有人能够编辑文档,因此,最终用户在继续之前必须知道密码。
因此,要让事情回到正轨,请右键单击,然后选择Unprotect Sheet,然后添加密码以将其解锁。
现在,由于我们使用的是Excel的(Excel)Office 365版本,这是该工具的较新版本,因此与旧版本相比,到达某些区域可能会有很大不同。
How to remove Read only from an Excel document?
You may have gotten an Excel file from someone, but you’re not able to edit it due to a strange Read-only notification. There are several ways to get around this problem, and like always, we are going to talk about it in a bit. Read-only is very common and means that the user is able to only read the file and not make any changes to it.
How to remove Read-only from Microsoft Excel
If you wish to edit or make changes to the Excel document, you can remove Read-only attribute by following any one of these methods:
- Use Edit Anyway button
- Save the file
- Read-only recommended and password lock
- Protected sheets.
1] Edit Anyway
The typical read-only error simply requires the user to click on a button that says Edit Anyway. Once that is done, the user will now be able to make changes to the document in any way they see fit. Very straightforward and to the point. While this may not work all the time it is the first thing you should try. This may not work if it is password protected –
2] Save the file
OK, so the next way to fix the read-only problem, is to save the file. Clicking on the Save button above won’t work, therefore, we have to take advantage of the Save As function. In your Excel document, select File, and from there, click on Save As.
Choose where you’d want to save the Excel document and that’s it, you’re done. Go ahead and open the newly saved Excel doc and you should have the ability to edit and make whatever changes.
This also works if you get an error saying The Excel File Is Restricted. Just follow the steps and you should be good to go.
3] Read-only recommended and password lock
If you are in a situation where the entire document is locked and requires a password to unlock, then this may help you. This will also work if read-only is recommended when opening an Excel document, so keep reading.
OK, so the first thing you will need to do here is, click on File, then Save As. After that, click on More Options, then from the window that appears, look below for Tools.
Select it, and right away you should see the option to add a password to open the file or uncheck the Read-only box.
4] Protected Sheet
It is possible to protect a sheet in Microsoft Excel. We can do this by right-clicking on the name of the sheet, then select Protect Sheet and make sure to add a password. A protected sheet means no one will be able to edit the document, therefore, the end-users must know the password before going forward.
So, to get things back on track, right-click, then select Unprotect Sheet, and add the password to unlock it.
Now, since we are using the Office 365 version of Excel, which is the newer version of the tool, getting to certain areas might be much different when compared to older versions.