How to put a password on Excel

Having created a document in Excel, many people need to protect Excel with a password. Protection in Excel is different. You can protect an Excel sheet so that it cannot be copied or modified. You can put a password on the Excel file so that they cannot open it and see it, or they can open it, but they cannot make changes. Sometimes you need to protect cells in Excel from being copied and changed.

How to password-protect Excel

To password-protect Excel, you need to click File - Details - Encrypt with password in the toolbar.

How to put a password on an excel file

A small window will open in which you will need to write a password and click OK. Another window will open in which you will need to enter the same password again to confirm. After that, to put a password on Excel, you will need to close it with confirmation of saving the changes. Now, when opening a file, you will need to enter a password, otherwise you will not see what is in this file.

To remove the password from protecting an Excel sheet, you need to know the password

To remove the password from an Excel file, you will first need to open it with a password, and then click File - Details - Encrypt with a password. A window will open in which you will need to remove the protection from the Excel by deleting the password so that the password field remains blank and then click OK.

How to password-protect an excel file

To protect Excel from copying, you need to click File in the toolbar and select Save As.

In Excel, password protection is triggered via File

A window called Save Document will open. In this window, you need to click on the Service and select the General options item from the list that opens.

Excel password protection is in general options

A window will open called General Settings in which there are two lines in which passwords fit.

When setting an Excel password, you need to write it down somewhere so as not to forget

If you enter the password only in the first line, then the file will be opened only with a password, but documents can be changed.
If you enter a password in the second line, then the file will open without a password, but it will not be possible to save this document with any changes made to it, but you can save this document with changes under a different name. A saved document under a different name will be password protected only for opening the file, and there will no longer be a password for copy protection on it.
To remove protection in Excel, you will need to click the file again and select Save As, and then in the window called Save Document, click Tools and select General Options from the list that opens. A window will open called General Options in which you need to remove protection in Excel by deleting all passwords in the form of dots so that the fields are clean and click OK.

How to Protect Cells in Excel

In some cases, it is necessary to protect Excel from editing and copying, but at the same time, so that data can be entered into some cells. To do this, select the cells in which you want to enter data, hover over them and press the right mouse button. A context menu will open in which you need to select the Format Cells item. A window called Format Cells will open.

You need to unprotect Excel for the cells you selected

In this window, on the Protection tab, uncheck the Protected cell item and click OK. After that, on the toolbar in Excel, go to the Review tab and click on Protect sheet.

Protecting a sheet in Excel from copying

A window called Sheet Protection will open.
In this window, you need to uncheck all the checkboxes except for the item Highlight unlocked cells, and enter some password in the box to disable sheet protection. By clicking the OK button, another window will open in which you need to enter the same password for confirmation and click the OK button. After that, it will not be possible to make any changes on this sheet, and it will also be impossible to select except for those cells from which you previously unprotected in the Format Cells window.
To remove protection from an Excel sheet, go to the Review tab and on this tab click Unprotect sheet.

How to remove password from excel sheet

A window called Unprotect sheet will open. Now, in order to unprotect a sheet in Excel, you just need to enter the password and click OK. Thus, you can easily remove the password from Excel, and if necessary, you will need to re-set it. However, if you do not agree with saving the changes when closing the excel file, then you will not be able to remove the password from excel and the protection will remain enabled.

Video

this video shows how to protect a sheet from editing and copying, while excluding individual cells.