How do I lock excel and let others open it in read only mode?

1. First of all, we right-click on the computer desktop.

On an excel document, the interface that pops up and we click on Properties;

2. In the pop-up interface, we will check the read-only check, then click Apply, click OK, so that the excel document is a read-only property;

3. If you cancel the read-only, it is also very simple, we right-click on the read-only excel document just now, and the interface that pops up, we click Properties;

4. We cancel the read-only checkbox, then click Apply, and then click OK, so that it is read-only mode.

1. First open the Excel** file you want to set as read-only mode, and then click "File" in the menu bar

2. After clicking "File", we will open the Excel** setting page as shown in the figure below, where we want to use the "Protection Workbook".

3. Click "Protect Workbook", and then select "Mark as Final" in the menu list that opens, as shown in the figure below.

4. After clicking "Mark as final", a prompt box will pop up "This workbook Jiangbei is marked as the final version and saved", and click the "OK" button directly.

5. Go back to the excel** page, or close the file and reopen it, which will pop up a read-only prompt box as shown in the figure below, click the "OK" button below.

6. After Excel is set to read-only, the "read-only" file will be displayed above the title bar of Excel, and the area of Excel** will also display "Mark as final version." Read-only prompt message.

Steps. 1. Open the excel file that you want to set to read-only mode and not allow modification.

2. Click the icon in the upper left corner, click Ready, and select read-only mode.

3. Click Confirm to set it to read-only mode.

4. Then a prompt will pop up, just click OK.

This file is locked and someone else opens it in read-only mode.

If you open the Excel document exclusively and keep it open, others will receive the above message when they open it.

This should be that the file has been opened by someone else on the network, so it is read-only mode.

Local excel sharing can't be shared by multiple people, and if there are more people, you will be restricted from reading, and you can't set permissions flexibly.

Solution:Web Excel - Thunderbird**, multi-person at the same time without limit. (The avatar and operation area will also be displayed to prevent confusion).You can flexibly set read-only, comment, and even control cell permissions.

1. First of all, we right-click on an excel document on the computer desktop, and in the pop-up interface, we click Properties;

2. In the pop-up interface, we will check the read-only check, then click Apply, click OK, so that the excel document is a read-only property;

3、Cancel only random reading,It's also very simple,We right-click on the read-only excel document,The interface that pops up,We click on the properties;

4. We cancel the read-only checkbox, then click Apply, and then click OK, so that we can accompany the read-only mode.

The first way is to right-click on the properties of the file and check the read-only box.

The second way is to use encryption software to achieve the read-only effect, you can use the local folder of the computer or the data in the USB flash drive to carry out read-only permissions, others can only see, can not carry out other operations, folder read-only encryption.