Unable to insert row/column by right click

Excel 12947 views 8 replies

I am trying to insert row/column in excel using right click option, but i am not able to do the same.

I have tried going to excel option-Advanced-Cut, copy and paste - checked Show Insert Options but still the problem persist

I am also trying Ctrl Shift + even that is not working

 

Kinldy provide a solution

 

Replies (8)

For inserting row/column use ctrl + and not ctrl shift +

Highlight full row with cursor and then try right click...u ll get it
This may occur due to the usage of IT return software. I have encountered problem of this type recently. Microsoft forum has provided solution. There will be a repair option in microsoft excel, which can be done through "Add and remove programs". This resets the default settings for excel, so that the problem will be repaired. There is another solution however. Go to C:\Users\yourname\AppData\Roaming\Microsoft\Excel Rename Excel15.xlb to Excel15.old

check this:

https://answers.microsoft.com/en-us/office/forum/office_2007-excel/grayed-out-right-click-menu-options/04de39d7-a389-488c-91bc-be69b8243214

Aditya RVS  thanx a lot for provding proper solution

You are welcome Vijay..

Nice..its working thnx

Excel is the most powerful tool to manage and analyze various types of Data. This Microsoft Excel tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.

This free Excel videos for beginners course will help you learn Excel basics.

Click to see Videos - Excel Insert Rows & Columns | Excel Full Tutorials


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register