Unable to insert row/column by right click

vijay (Accountant) (834 Points)

11 September 2015

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

Reply Follow

8 Replies

Sheetal Jain (.) (869 Points)
Replied 11 September 2015

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

2 Like

raghavan (self) (611 Points)
Replied 11 September 2015

Highlight full row with cursor and then try right click...u ll get it

Aditya RVS (Practice) (221 Points)
Replied 11 September 2015

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

5 Like

@VaibhavJ (Believe!! Live your dreams!) (33496 Points)
Replied 13 September 2015

check this:

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

1 Like

vijay (Accountant) (834 Points)
Replied 14 September 2015

Aditya RVS thanx a lot for provding proper solution

Aditya RVS (Practice) (221 Points)
Replied 14 September 2015

You are welcome Vijay..

Sachin Dhobale (2 Points)
Replied 19 January 2019

Nice..its working thnx

Babita Jain (Personal Assistant) (153 Points)
Replied 10 May 2021

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