See all How-To Articles

How to Change a Read Only File in Excel & Google Sheets

In this article, you will learn how to change a read-only file in Excel and Google Sheets.

 

edit read only file excel

 

Change a Read-Only File Without a Password

To edit a read-only file that has no password protection, once you open a file, click Edit Anyway in the yellow read-only warning.

 

edit read only file excel

 

After that, you can change the file and save all changes.

Change a Read-Only File That Has a Password

If a read-only Excel file has password protection, there are two steps to follow to be able to change it.

1. When you open the file, in the Password pop-up, (1) enter a Password and (2) click OK.

 

edit read only file with password

 

2. Then click the Edit Anyway button, as in the previous section.

Set Permissions in Google Sheets

Google Sheets uses permissions for changes instead of read-only mode. To add permissions, follow these steps:

1. In the Menu, go to Tools > Protect sheet.

 

google sheets protect sheet

 

2. On the right side of the window, (1) enter a description of the setting, and (2) click Set permissions.

 

google sheets set permission

 

3. In the next window, leave the default option (Show a warning when editing this range), and click Done. This means that every time a user tries to change the sheet, they’ll be asked to confirm whether changes should be made.

If you select Restrict who can edit the range instead, only specified persons can change the file.

 

google sheets set permission 2

 

Now if you try to edit any cell in the sheet, you get the warning message in the picture below and have to click OK to proceed with changes.

 

google sheets set permission 3