logo
Computer Make an Excel File Read Only

How to Make an Excel File Read Only

By Sophia | Last Updated

Sometimes, we need to share our Excel file with others, in order to prevent it from being modified by others and causing data confusion, it is necessary to set the read only permission of Excel to protect the originality of the file. In this article will guide on how to make an excel file read only.

How to Make an Excel File Read Only

Option 1: How to make an excel file read-only with MS

Way 1:Make an entire excel file read only

Step 1: Open the Excel table, click "File" to enter the navigation bar.

click on file

Step 2: Locate the "Save As" option, save the file in "This PC", and then select the location to store the file.

save file in this pc

Step 3: Click the "Tool" drop-down arrow in the lower right corner, and click the "General Options" in the options box.

click on general options

Step 4: In the “General Option” dialog box, check "Read-only recommend" and set the password to modify the permission.

enter password to modify

Way 2:Make parts of the excel file read-only

Step 1: Select the file content that needs to be set read only, click the "Review" option in the toolbar, and then click "Protect sheet" in the option box.

protect sheet

Step 2: In the pop-up dialog box, enter the password to lock the file, click "OK", and then determine the password, you select the contents of the Excel file will be set to read-only mode.

click to set password

Option 2: How to make an excel file read-only with iSunshare SafeFile Genius

iSunshare SafeFile Genius is an effective tool for password protecting files and folders,setting Excel files to be read-only is one of its features.

Step 1: After installing the iSunshare SafeFile Genius software on your computer, launch it. Click the "Read-only & Hidden" option button.

click on read only button

Step 2: Click the file icon in the upper right corner to select the Excel file, select "Read only" in the selection box below, and then click "Setting".

select a file to set read only

Step 3: Soon, your Excel file will show the status of "Finished modify properties", at this time, the read-only status of your Excel file has been set up.

finished modify properties

Conclusion:

Setting read-only mode for your Excel files is a simple operation, but it can prevent your data from being tampered with and keep the integrity of your Excel tables. If you are interested in tips on how to secure Excel files, such as how to encrypt Excel files ,you can learn more about iSunshare SafeFile Genius.

Related Articles: