Recently I faced a peculiar problem with my excel sheets.
I was not able to insert columns and rows in the sheet in any way.
Yes in right click option of mouse the insert option was disabled.
This generally happens when you open a protected worksheet for example ITR form provided by Income Tax Dept of India.
After going through a number of options i came across the below mentioned technique to get it rectified in easy manner. So just follow the method.
1.
First of all, Save and Close all the workbooks which are open.
2.
Click on Windows Start Button at the bottom left corner, and then type "run"
without quotes in the "search program and files" and enter.
3.
Now copy and paste
%appdata%\Microsoft\Excel
in the space provided and click OK button.
4.
Now a directory will open
Rename the file: Excel**.xlb --> Excel**.old or you may also delete it as in both cases Excel will recreate a fresh setting file of the same name)
This method is already tested by me and one can apply it easily.
