It is well known that to protect information from unauthorized access in Microsoft Excel Could use multiple layers of protection. For example, you can disable change data in individual cells or deny any changes on a separate page of the book Excel. You can also set a password to open the file Excel, with all its contents will be inaccessible not only to change, but for the viewer. Sometimes there are situations when you need to change something in the file, Excel, that you have not used, but, unfortunately, on some pages of the document is protected. If you do not remember the password to such lists, to make changes to the document will not be possible without the use of any special tools. How to remove the protection sheet with Excel? This can be done, for example, using the program Manyprog Excel Password Recovery. It will help you easily and recover Excel password.
When you run the program and specify its path to the file from which you want to remove protection, it will give you a list of protected sheets. You can alternately specify the desired list, and the program will recover passwords to each of them. For maximum efficiency of the utility you need to specify some criteria for password recovery - presumably the number of characters that make it up, and their type. Advanced PC user can also connect their dictionaries to find passwords. In addition, the program allows you to specify a list of prospective passwords from which to choose the one that fits to the desired list.
Speaking of removing protection from a sheet Excel, not to mention how it is installed. To protect the data of an Excel worksheet can be as a whole or selectively. In the first case, the protection is placed on the entire sheet and all its cells are protected within the limits set. In the second case are protected only individual cell or range of cells. To protect the entire list, you must click on the name of the sheet, right-click and select "Protect Sheet". If you want to install protection only to individual cells, you can right-click on the selected cells in the "Format Cells" on the "Protection" check "Locked cell" (for unprotected cells, this option should be removed). Once all cells are marked that need to be protected, it is necessary to perform the protection sheet as described above.