how to make an excel spreadsheet read only

If you want to make your Excel files write protected and want to prevent unauthorized access and editing then follow these instructions on Microsoft Excel(2016). How to Make Excel Sheet Read Only (Excel 2016/2013/2010): Step 4: You can also set Password protection by typing in a strong password in “Password to Modify” textbox. Step 3: Check the “READ-ONLY RECOMMENDED” box to mark the file as read-only, optionally you can follow step 4 to add an extra layer of protection by password.

Step 2: Go to “Tools>Options>Security”, you will see the following UI on your screen.

Step 1: Open Excel file you want to mark as read only for protection. One thing must be clear here that enabling “read-only” alone won’t make your excel file 100 percent safe, you will need to set password decryption too this is how you do it: How to Make Excel Spreadsheet Read Only (Excel 2003/2007):īy default all files created have read and write access however you can restrict this by marking the file as read-only, this will disable editing of file and make sure no unauthorized changes are made. Password protections come in 2 general types, one is to prevent opening of the file and other password protections restricts modifications. However, the user can still modify the file, in order to prevent that you will have to set password encryption to make sure no unauthorized changes are made. The problem with this solution is that it only shows warning whenever someone will try to make changes in the file. Step 2: Now, click “Protect Workbook” and select “Mark as Final”. Step 1: Click “File” in the menu bar and then Select “Info”. The very first thing you can do is to “Mark as Final” it will not make Excel read-only but as the name suggests, it will tag the file as final document and give a warning message whenever someone tries to makes changes in document, this is how you do it: Solutions on How to Make Excel File Read Only

If you want to know how to make an Excel file read only then follow this guide. Password encryption is recommendable when you are dealing with multiple employees or want to prevent accidental deletion of the important data file. This not only makes the file harder to access but also requires password input for making any changes in the file. Sensitive or private data stored in Excel files can be marked as read-only to add a layer of security on top of it. When multiple people have to access spreadsheets in a company then it is very crucial to prevent all sorts of unauthorized access and modification.

How to make an excel spreadsheet read only