passper

How to Enable Editing in Excel 2019/2017/2016/2013/2010/2007

author_icon William Wilson time_icon Last updated: Feb 18, 2020 10:16 am tips_icon Excel

Are you stuck looking for how to enable editing in Excel read-only? Have you tried multiple options and still found yourself in the same loop? Worry no more because we have good news for you. To access the file in an editable mode, you need to perform some operations on the Excel file. These processes vary depending on the type of protection in question as discussed in detail in this article.

Part 1: Directly Disable Protected View to Enable Editing in Excel

When you try to open a downloaded file in Excel, the worksheet will automatically open in a read-only mode meaning you can only view but you cannot edit or apply other commands. In this case, there are plenty of ways to disable protected view in order to enable editing on your Excel file. One of the most straightforward options is to do it directly via program settings. This method will open the Excel file in editable mode and prevent it from displaying protected notification every time you open the file. This helps to save the time required to disable the protected view every time you open the Excel file. To disable the protected view directly, follow the steps below.

Step 1: Double-click the Microsoft Excel icon on your desktop to access the primary interface. Once opened, navigate to "File" and choose "Options" from the subsequent list.

Step 2: From the displayed "Excel Options" window, choose "Trust Center" > "Trust Center Settings" on the bottom left pane.

trust center excel options

Step 3: Click on the "Protected View" and then uncheck any or all of the protected view options given. Once satisfied, click "OK" to directly apply the settings.

trust center protected view

Part 2: Other 4 Ways to Enable Editing in Excel Read Only

Protected View is one of the most common situations you will meet if you download files from the Internet. Of course, you will also encounter some other cases where you need to enable editing in read-only Excel file. In this section, we will list 4 common cases and solutions as well.

Case 1. Excel File is Marked as Final

How to know that your Excel file is Marked as Final? When you open a read-only Excel file Marked as Final, there is a yellow notification on top of the Excel worksheet. This notification is a warning that the author of the Excel file has denied you to edit the Excel sheet. This means you can only read the contents of the workbook but not perform operations like typing, editing, and engage proofing marks and commands.

In order to edit the Excel file Marked as Final, you need to get rid of the read-only feature. This is simple as you can simply click the "Edit Anyway" button within the "MARKED AS FINAL" notification at the top of the worksheet.

excel mark as final

Case 2. Excel File is Recommended as Read Only

In the case where you open an Excel file recommended as a read-only, it is usual to get a pop-up window asking you to open the file in read-only mode. Selecting "Yes" will open the file in read-only mode and you cannot apply any changes. However, if you want to make any changes to this file, choose "No" instead.

open read only excel

Now if you want to remove read-only recommended feature for good, then do the following.

Step 1: Open the Excel file recommended as read-only and select "No" from the pop-up window.

Step 2: Navigate to "File" then choose "Save As" to open the file directory. Click the drop-down icon beside "Tools" at the bottom of the file explorer window and select "General Options".

Step 3: The "General Options" window will open. Locate and uncheck the "Read-only recommended" box. Click "Ok" to complete the removal of the read-only recommended mode on your Excel file.

uncheck read only recommended

Case 3. Excel File is Protected with Modifying Password

If you try to open an Excel file that is protected with a modifying password, a pop-up window asking you to enter the password will appear. In this case, it is really easy to enable the editing mode whether you know the correct password or not.

If you know the correct password, just type it within the prompt. Then go to the "File" option and select "Save As" from the subsequent list. Delete the password in the "Password to modify" field in the "General Options" dialogue box. Now, you will receive a Excel file without protection.

delete password to modify in excel

If you don't know the correct password, then the only option for you is to open this Excel file in the read-only mode. After opening, press "Ctrl+A" to select the whole worksheet and then press "Ctrl+C" and "Ctrl+V" to copy the content to a new worksheet. You can edit the new worksheet as you wish now!

copy and paste excel sheet

Note

This method only works when you can select the content. Sometimes, you are not allowed to select the cells if the "Select Locked Cells" and "Select Unlocked Cells" options are forbidden by the owner. If this is the situation, you can try the solution in Case 4.

Case 4. Excel Worksheet is Protected with Password

In this case, you won't know that the worksheet is password protected until you want to select or edit some cells. An "Unprotect Sheet" dialog box will pop up requiring you to enter a password. Different from the above 3 cases, an Excel worksheet protected with a password can only allow you to open the file in editable mode if you know the password. The only way that is easy to use and 100% workable is by using a password remover tool.

Passper for Excel is the best password remover tool for Excel worksheets or workbooks. By using Passper for Excel, you do not have to be a tech-savvy since it is really easy to use. With one simple click, all restrictions can be removed with 100% success rate. Additionally, Passper for Excel is helpful to recover opening password for all types of Excel file.

Passper is a sub-brand of the hi-tech corporation iMyFone, which has been trusted and recommended by many professional websites like Cnet, Cult of Mac, etc. Before you decide to use this program, you can also check the user's feedback below.

media sites
passper good user review

Now follow the simple steps below to enable editing in your Excel file. Start by downloading and installing the program on your computer or laptop.

Free Download for Win 10/8.1/8/7/XP

Step 1 Open Passper for Excel on your PC to access the main interface. Choose "Remove Restrictions" option.

choose remove restrictions mode

Step 2 Click on the "Select a File" button to upload your password protected Excel file. Once the restricted Excel file has been successfully uploaded onto the program, simply hit the "Remove" button to activate the removal process.

upload protected excel file

Step 3 The process is super-fast and will take about 2 seconds to complete. When it is successfully completed, the program will display a success notification. Your Excel file is now restrictions-free and you can freely edit it.

remove restrictions successfully

Conclusion

As you have seen from the information above, it is clear that there are several options for enabling editing on read-only Excel worksheets or workbooks. After reading this article, you can easily edit your protected Excel file no matter what the case is. If you have any doubt about the above solutions, you can turn to the comment section below and leave us a comment. We will try our best to help you!

user

By William Wilson to Excel

Posted on Feb 13, 2020 ( Updated: Feb 18, 2020 )

William Wilson, a blogger who is interested in MS Office software. In the past three years, William has been trying to write articles to help people better understand MS Office software.