Looking for ways to know how to enable editing in Excel? Then, this is the right place for you. Generally, excel files can be in different forms such as password-protected, protected view, read-only files, etc. To enable editing of these files, you have to follow different steps. Here, you will find 5 different step-by-step explained ways to enable editing in Excel.
Download Practice Workbook
Enable Editing in Excel Files.xlsx
5 Ways to Enable Editing in Excel
Here, we have 5 different cases where we have to enable editing. These files are in different forms such as protected view, marked as final, read-only, and password protected. Go through the following steps to enable editing your Excel files.
1. Using Excel Options to Enable Editing
Sometimes, when you open an Excel file, you may try to use Edit mode but are unable to do that. In that case, you can apply edit mode by changing an Excel Option.
Here, you can find a dataset that is unable to be edited.
You can apply Edit mode by following these few steps.
- First, click on the File tab.
- Then, click on the Options bar.
- Now, the Excel Options dialog box will appear.
- Then, go to Advanced and enable Allow editing directly in cell.
- Finally, press OK.
Now, you can edit the file by clicking on the cell.
Read More: How to Unlock Excel Sheet for Editing (With Quick Steps)
2. Using Info Feature to Enable Editing in Excel Protected View
We can enable editing in Excel in a protected view in different ways. Follow the given steps below to allow editing your Excel file in a protected view.
When you open a protected Excel file it will look like the following dataset.
- Click on the Enable Editing button to enable the editing of the file.
- After that, you may edit your Excel file as you wish.
There is another way of solving this problem. You can also use Info Feature to enable editing of a protected file in Excel.
- In the beginning, click on the File tab.
- Then go to the Info bar and click on Enable Editing.
- After that, a box may appear asking if you want to open it as read-only.
- Click on No.
- Finally, you can now Edit your file as you wish.
Read More: Cannot Edit Excel File in Protected View (3 Reasons with Solutions)
- How to Edit a Cell in Excel (4 Easy Methods)
- Edit Cell in Excel with Keyboard (4 Handy Methods)
- How to Edit Cell with Single Click in Excel (3 Easy Methods)
- [Solve:] Cannot Edit a Macro on a Hidden Workbook (2 Easy Solutions)
- How to Edit a Cell in Excel without Double Clicking (3 Easy Ways)
3. Clicking on “Edit Anyway” Button to Enable Editing for Marked as Final Excel Files
Excel files can be as Marked as Final files. You can not edit these files unless you enable editing. The Marked as Final file may look similar to the dataset given below.
- Click on the Edit Anyway button to enable editing.
- Now, you will be able to Edit your file as you wish.
Read More: How to Edit a Macro Button in Excel (5 Easy Methods)
4. Click on “Edit Anyway” to Enable Editing for Read Only Excel Files
Read-only files are another form of Excel file where you need to enable editing before editing that file.
Here, you can find a dataset that is in Read-only form.
Follow the given steps to enable your Read-only Excel files.
- Click on the Edit Anyway button to enable editing of the file.
- Now, you will find your cells in editing mode and may Edit them as you wish.
5. Using Password to Enable Editing for Password Protected File
Sometimes, Excel files can be Password Protected and may also have modified passwords. In that case, follow the following steps to enable editing of password-protected files.
- When you open a Password Protected Excel File a box asking for a password will appear similar to the box given below.
- Write down the Password of that Excel File.
- Here, the Password is 12345
- Then, click on OK.
- If the file also has a Modified Password, another box may open asking for Password.
- Write down the Modified Password.
- Here, the Password is 6789
- Then, click on OK.
- Finally, you can now Edit your excel file.
So, in this article, you will find 5 ways how to Enable Editing in Excel. Use any of these ways according to the Excel file type you are using to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!