Dear friends

I am using microsoft office 2010. In excel 2010 in datasheet i am not able to insert column or row through right click of mouse.

Please help me as all solutions given on internet are not working. I have installed office 2010 several times but issue was as it is.

Hi,

Regarding of the issue, please provide us more information to assist you better.

• Was this issue occurred with all Excel file (Even a blank file) or a particular file?
• Was there any error message?
• Have you tried the shortcut key (Ctrl+Shift+=)?

If you receive an error message that is similar to the following:

To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet.

Please try the following steps:

• Click the heading cell in the first blank column to the right of your data. (The heading cell is the first cell in each column, and indicates which column you are in).
• Press and hold down CTRL+SHIFT, and then press the RIGHT ARROW key to select all of the columns to the right of the first column that you clicked.
• On the Edit menu, click Delete.
• Click the first blank row below the last row in your data.
• Press and hold down CTRL+SHIFT, and then press the DOWN ARROW key to select all of the rows below the first row that you clicked.
• On the Edit menu, click Delete.
  
  Note To remove any formatting from the remaining cells, continue to follow these steps.
• Click the small cell between the first row heading and the first column heading to select the entire worksheet.
• On the Format menu, click Cells, and then click the Border tab.
  
  Note The formatting added to the remaining cells may vary. Step 8 assumes that you want to remove border formatting. To remove other types of formatting, you may need to change settings under another tab in the Format Cells dialog box.
• Click None, and then click OK.
• Click any cell in the row where you want to insert a row.
• On the Insert menu, click Row. To insert a column click Column.

Reference:

https://support.microsoft.com/en-us/kb/305568

Regards,