In this article, you will learn how to change a read-only file in Excel and Google Sheets.
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.
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.
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.
2. On the right side of the window, (1) enter a description of the setting, and (2) click Set permissions.
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.
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.