Unable to insert row/column by right click

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details