Free Project Management Tools - Tutorials,Ebooks and Setups

If an Excel spreadsheet is password protected, we are unable to edit the data in the sheet. If you do not remember the password or if you don't know the password to unprotect the excel sheet then just follow this process for unlocking the excel sheet. Step 1:  Open the Excel sheet Step 2: Press Alt + F11 or click on view code on the developers tool Then you would be seeing a sheet like this Step 3: In the above white space, just enter the code as shown below(Just Copy paste) Sub PasswordBreaker()     'Breaks worksheet password protection.     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     On Error Resume Next     For i = 65 To 66: For j = 65 To 66: For k = 65 To 66     Fo...

Let us learn how to Autofill the Data in the Microsoft Excel 2013. In 2013 it would be very easy to autofill by just entering the data in one cell, placing the cursor at the right corner of the cell and then just dragging the cursor down. Microsoft Excel 2013 detects the format of the data that you have entered and it will autofill in the same format of the cell that you have entered. This can even be done using a shortcut. If you would like to autofill the data in a single columns without dragging the cells, just place your cursor in the cell and by pressing the shift  key select all the cells in the columns upto which you want to autofill the data and then press Ctrl+D. Similarly for doing the same auto fill by Rows, press Ctrl+R . Video Shown here for better understanding. Back to MS Excel>>