Today we will discuss how to password protect an Excel file. This tool is part of Microsoft Office. Excel provides the ability to create tables of varying complexity, use formulas, as well as individual design. All current versions of the application support password settings.
Instruction manual
We turn to a phased description of the process of how to password protect an Excel file. This opportunity is provided to files in * .xls format, like any other Microsoft Office documents, including Word and Access. So, after finishing work with the document, click the “File” button, which is located in the menu at the top of the Microsoft Excel window. In the list that appears, turn to the “Save As” item by clicking on it once with the left mouse button. A window for saving the document will appear, in it we find the menu “Tools”, click the inverted triangle, and then use the appeared function “General Settings”.
Customization
We move on to the next step in resolving the issue of how to password protect an Excel file. The “General Settings” section appears on the screen. Here you must enter the password to change or open the document. In addition, if you activate the Read-Only function, when you try to open a password-protected Excel file, the
toolbar will be disabled by default.
If you set up protection only to start a document, an input request will appear every time the table is opened. Moreover, all users who know the secret combination will be able to create arrays and edit data. Regarding the question of how to open a password-protected Excel file , if protection is set to change the material, the launch will occur standardly, without any requests. However, if you add new data to the table and try to save the document, the application will ask you to specify a secret combination.
When both types of passwords are set, double entry is required during start-up and closing of the material. It is important to know that you can set different passwords for editing and opening a file.
Back to the setup. When the password (or a couple of them) is set, click on the "OK" button in the "General Settings". In the explorer we enter the name of the document, save the file using the corresponding function.
Remove protection
Next, we discuss how the password is disabled in Excel. To solve the problem, additional software is not necessary, since the function is provided by the built-in application tools.
We start Excel. Open the document that you need to get rid of password protection. We use the "File" menu. Specify "Save As", and then open the "Service" menu. Go to the "General Settings", apply the double-click on the stars in the password bar. Use the "Del" key for the desired action. Confirm the operation by pressing the "OK" button. Click "Save", and then "Yes" in a new window.
That's all, the password in the Excel workbook is cleared. With a sheet, everything happens in a similar way. We open the menu "Service", we use the command "Unprotect". To confirm the cancellation, you will have to enter the previously assigned password. From now on, you know how to password protect an Excel file, and also how to cancel protection if necessary.