Share via

Alt+I C or R shortcut is not working anymore

Anonymous
2015-08-10T07:56:16+00:00

Dear all,

The shortcut Alt+I and C or R to insert column or row has stopped working anymore in my Excel files (Office Professional plus 2013). It was working about a month ago. Please help to fix it, if possible.

regards,

subhadip

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Vijay A. Verma 104.8K Reputation points Volunteer Moderator
2015-08-10T08:03:40+00:00

Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name) and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank. If you don't want to move all files/folders, you need to look for files having extension of .xlb. Rename this file to something else. 

Now open Excel and see if the problem disappears or not. 

Note - to find Excel path, you need to find XLSTART path. Excel folder contains XLSTART folder in itself.

  1. Open Excel
  2. ALT+F11
  3. If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window
  4. Type "? application.StartupPath" without quotes and press enter
  5. You will have your path below.

Was this answer helpful?

3 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-08-10T08:29:55+00:00

    Thanks a lot, Mr Verma. Now it is alright.

    Best Regards.

    Subhadip

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments