Keyboard shortcut Alt+I+R for inserting row is not working
Empty the Excel folder including XLSTART, then refresh the Excel workbook. It should work (Alt+I+R for Insert Row and Alt+I+C for Insert Column).
To locate the Excel folder in your system follow the steps below:
1. Open an Excel workbook (New file or existing)
3. If “Immediate Window” is not visible, type CTRL+G. Alternatively it can be accessed through View >> Immediate Window
4. Type “? application.StartupPath” without quotes and press enter
5. You will see the path below
I also suddenly discovered Alt + I + R refuses to insert a row. I use Excel 10
Now I have found a way around it. Use Alt H + I + R – yes an extra key stroke, which calls Home menu then Insert then Row
That always works for me. Why Home menu is not default as before haven’t figured out
Even I discovered one day that my Alt+I+R is not working. Tried a lot searching for the reason and correction (and my IT team was not at all helpful for this) 🙁
While trying options suggested by others on this platform, I found a new command which is working perfectly. Try Alt+I+E in place of R. For me, it is working.