N/APosted on - 01/13/2012
I have protected my Excel worksheet using a password. Now, when I try to access the file by entering the password, it is not recognized. How can I resolve the issue? I would also like to increase the rows and columns in the Excel worksheet. How do I make this work?
How to recover password on protected worksheet
Try changing the case when entering the password in Microsoft Excel. Or if you really forgot the password used in your Excel file, try downloading Free Word Password / Excel Password Recovery Software at http://www.freewordexcelpassword.com/.
If you want to increase the size or customize the length or width of certain rows and columns, you can point your mouse between the rows or columns until the mouse pointer changes then just drag it to change its current width or height.
Or you can right-click on the upper-most part or left-most part of the worksheet and then choose Column Width for the columns or Row Height for the rows like what the images shown below.