Excel is one of the best ways for maintaining the records and other information that is generally in numerical form. This type of storing data is developed by Microsoft that already is in tabular form and can also be converted into pie charts, graphical form etc. Storing the data using this application is preferred generally to maintain official records or any factory records.
Many other companies have developed this type of record maintaining format, not to forget Google who has introduced Sheets in its Email application making it convenient for the users to maintain and share the details and records. Now when sharing the data comes to play the role and seeing the increased rate of online data leakage, people started locking their data while sharing to avoid any kind of leakage. Hence, protecting your Excel file is nowadays a known way and that can be unlocked easily by entering the password.
Simple steps to unlock Excel File Without Password
When you create the password to protect your data from leaking in your excel file then it can be done easily. But, in case you do not know the password and want to unlock Excel file password then it also has very simple steps. But in case you need to unlock the excel file that is without password then you need to follow the steps below.
-
Open your excel sheet from the place it has been stored by clicking on it.
-
When the password is asked to unlock your excel file then press “ALT+F11” simultaneously to open a window that is black or white in colour known as the visual basic screen.
-
In the window that is displayed, right-click the name of the worksheet and then select “Insert Module” from the menu.
-
A window will be displayed as “Password Breaker” and you need to enter the following command to break the password settings:
Dim I As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "Password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
5) After entering the command above, press F5 and wait for few minutes.
6) You will now be able to see the password and unlock your excel password protected file.
7) Press “OK” to unlock your excel sheet.
Contact Microsoft for Assistance
In case you are not able to understand the steps above then you can contact Microsoft support assistance center for any kind of getiing instructions at any time as they are available working days, so that you can contact anytime. With the above simple steps, you can definitely unlock your excel file without a password. In case, you require any further information, then feel free to connect service point.