Then choose the General Options from the Save As dialog and press OK.

Initially, open the read-only excel file.

You can make an excel file editable again by following the below steps. Read More: How to Make a Cell Read-Only in Excel (2 Simple Methods)ĭisable Excel ‘Read-only-recommended’ Option No one can change the original excel file that we have protected with a password. The message in the box ensures that our file is fully protected now.

After editing the data, if you click on the Save option, excel will show the below warning box.

Here, you may think excel is allowing me to update the value even though the workbook is in a read-only file.

After opening the file, let’s consider that I want to modify any sales value.

As a result, the file will be opened as usual like in the below screenshot.

First, double click the excel file which we made read-only, and enter the password.

Now let’s check whether our file protection works or not. Suppose, you want to open the read-only file that we just have created. Step 4: Open Password Protected Excel File to Check Excel now saves the excel workbook as a read-only file with a password.

Consequently, excel will get back to the General Options dialog, press Save.

Again enter the password when the Confirm Password prompt box appears and press OK.

From the box, put a checkmark on the Read-only recommended and type a suitable password in the Password to modify field.

Upon clicking on the General Options, the below dialog box shows up.

Now, give a name to the excel file and go to the bottom section of the window to choose General Options from the Tools.

After browsing, the Save As dialog appears.

Next, from the Excel Ribbon, go to the File tab.

First go to the corresponding datasheet, where we have the data.

So, now I will make the excel file read-only and will apply a password to restrict unwanted access and modification of data. Step by Step Guideline to Make Excel Workbook Read Only with Password Step 1: Use File Tab from Excel Ribbonįor instance, we have a dataset containing some products’ month-wise sales data.

How to put a password on an excel sheet