In my system Excel Alt+I+R (for insert row) is not working.

In my system Excel Alt+I+R (for insert row) is not working. Any solution is there?

Enthusiast Asked on 17th August 2015 in Excel for Windows.
Add Comment
  • 3 Answer(s)
    Best answer

    Hi,
    Empty the Excel folder including xlstart, then refresh the excel it will work (Alt+I+R for insert Row and Alt+I+C for column).

    IF you want to find the excel folder in your system then go through the below steps.

    1. Open Excel (Any file new or existing).
    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.”

    Thanks.
    M Madhu

    Enthusiast Answered on 23rd August 2015.
    Add Comment

    Please have a look at this thread.

    Enthusiast Answered on 17th August 2015.
    Add Comment

    HI,
    You may clear the files from XLSTART folder and verify whether issue re-occurs.

    Access XLSTART folder from the following location.
    \Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART

    Note: The AppData folder is hidden by default. Unhide the same by following steps mentioned below.

    1. a) Start Button Control Panel > click on Appearance and Personalization.
    2. b) Click on Folder Options > go to the tab View > check Hidden files and folders: Show all files and folders.
    3. c) Now click on Apply and OK.

    Refresh the Excel File or restart the system. It will Work.

    Enthusiast Answered on 30th August 2015.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of use.