Many users, who often need to use in his work office application Microsoft Excel, know that it is possible to install protection for both the entire document Excel, and the individual elements of the document, such as sheets, ranges of cells, and so on. Especially regarding the protection of Excel documents used in enterprises or companies with the collaboration of several users with the same file Excel. The problem is that passwords are sometimes lost and if it is a file from your desktop computer, you can contact your system administrator with the question of how to recover Excel password, which you have forgotten. If this file is located on your home computer, the problem can be solved by using a special program that will help restore the password to the Excel file. This is a problem, for example, can easily handle software Manyprog Excel Password Recovery, you can download the link, located under the screen shots.
MS Excel application allows users to protect information contained in documents Excel, in several different ways. The easiest way out is to protect them from entering incorrect data in a particular cell. If the user enters incorrect information in a secure cell (for example, a fractional number of people), an error message. Another method of protection is used when necessary to protect against changes in cell individual sheet. In this case, you can prevent users to edit cells using specially installed to protect the current sheet Excel. This can be done using the command "Protect Sheet" (in Excel 2007, this button is located on the "Review"). This will open a dialog box where you can set a password to protect the sheet, as well as various exceptions, such as permission to insert rows or columns.
When working with the same document, Excel sometimes happens that each user should only see a range of cells, located on the same sheet. This is done selectively protected cell ranges for different users, which can also be set on the "Review" with the option "Protect Sheet". If you need to protect all the sheets of the Excel workbook delete or rename, and prevent changes in the structure of the book, is used to protect the entire Excel workbook with the button "Protect the book."
And finally, if necessary encrypt the entire Excel workbook file, it is possible to set a password for the whole Excel file as a whole. This can be done when saving a file Excel, choose the option "Save as" and then in the menu "Tools" select "General Settings" and in the window that appears, specify a password for the selected file Excel. This password is to come up with the best of those that you can easily remember for a long time, or burn it away and somewhere away from strangers. If you do forget the password for the document Excel, and passwords on its individual sheets, or lost them, you must use the password recovery Excel. Video, which is located below clearly rocked how to work with such a program.