How to Change an Excel Sheet from Read Only

You can easily change your own created Excel sheet from Read-only mode. But, if you want to convert an Excel sheet from Read-only mode that is created by others then you may face some limitation issue. In this video, we will learn how to change an Excel sheet from Read-only mode. Let's follow these steps.

1. Open an Excel sheet that you have created with a Read-only mode. Click on the File menu at the top left in Excel.
2. Click on the Open from the menu list. Go to the file-saved location on your computer.
3. Select an Excel file, and then click on the open button.
4. If an Excel sheet is password protected, then you must have the password of this file. Type your password in the Password text box and then click on the OK button.
5. If the password window prompts again then type the password again in the box, and click on the OK button.
6. An alert box will appear which is asking you to open this file as read-only? Click on the Yes button.
7. The file will open as read-only, and you will notice Read-Only text along with the file name.
8. Let’s try to write something on this Excel sheet.
9. Click on the File menu at the top, and then click on the Save As.
10. In the Save As window, click on the Tools drop arrow, and then click on the General Options…
11. Uncheck the checkbox of Read-only recommended, and then click on the OK button.
12. Click on the Save button.
13. In the confirmation box, click on the Yes button to replace the file name.
14. Close the Excel application, and reopen the workbook which I just have changed from Read-only.
15. See, this time we didn’t receive any alert message of Read-only.

Hope this was easy. Have a nice day!
Please subscribe to our channel.

Content in this video is provided on an "as is" basis with no express or implied warranties whatsoever. Any reference of any third party logos, brand names, trademarks, services marks, trade names, trade dress and copyrights shall not imply any affiliation to such third parties, unless expressly specified.

[Hristoss]

What about if the box isn't checked but still says it's for read only

[unknwn_usr]

How to select some portion and make it read only...?