All the sudden, MS Excel's insert Row / Column option is disabled after right clicking.
I have tried using Excel options, but it's not working. How do I enable it?
Answer is simple. Just follow the steps.
1. Close all open Excel windows
2. In Windows Explorer, go to directory "%appdata%\Microsoft\Excel"
3. Rename the file: Excel15.xlb --> Excel15.old
Voila! Now, Open the Excel and try to insert the row / column. It will be re enabled now.
No comments:
Post a Comment