How to Enable Editing in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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

To open the file use the password 12345 and to modify the file use the password 6789


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.

How to Enable Editing in Excel

You can apply Edit mode by following these few steps.

Steps:

  • First, click on the File tab.

Enable Editing in Excel Using Excel Options

  • 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.

Enable Editing in Excel Using Excel Options

Now, you can edit the file by clicking on the cell.

Enable Editing in Excel Using Excel Options

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.

Enable Editing in Excel In Protected View

Steps:

  • Click on the Enable Editing button to enable the editing of the file.

  • After that, you may edit your Excel file as you wish.

Enable Editing in Excel Clicking Enable Editing

There is another way of solving this problem. You can also use Info Feature to enable editing of a protected file in Excel.

Steps:

  • In the beginning, click on the File tab.

  • Then go to the Info bar and click on Enable Editing.

Using Info Feature Enable Editing in Excel

  • 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.

Using Info Feature Enable Editing in Excel

Read More: Cannot Edit Excel File in Protected View (3 Reasons with Solutions)


Similar Readings


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.

Clicking on Edit Anyway Enable Editing in Excel

Steps:

  • Click on the Edit Anyway button to enable editing.

Clicking on Edit Anyway Enable Editing in Excel

  • 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.

Clicking on Edit Anyway to Enable Editing

Follow the given steps to enable your Read-only Excel files.

Steps:

  • 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.

Clicking on Edit Anyway to Enable Editing

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.

Steps:

  • When you open a Password Protected Excel File a box asking for a password will appear similar to the box given below.

Using Password to Enable Editing in Excel

  • 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.

Using Password Enable Editing in Excel

  • Write down the Modified Password.
  • Here, the Password is 6789
  • Then, click on OK.

Using Password to Enable Editing in Excel

  • Finally, you can now Edit your excel file.


Conclusion

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!


Related Articles

Arin Islam

Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo