I've noticed that I'm no longer able to use shortcuts like Alt-IR and Alt-IC to insert rows and columns. I'm sure I used to be able to on this machine but recently it doesn't work any more.

How do I get these shortcuts back?

  • Does anything else get triggered instead with Alt+I? Do you have any app running that could have set a global shortcut for that key combination? – Karan Jan 23 '13 at 16:35
  • No, nothing else gets triggered (just a "ding" error noise) and it happens even when Excel is the only thing running. – Jamie Bull Jan 23 '13 at 17:48
  • So even with Excel closed pressing Alt+I makes an error noise? – Karan Jan 23 '13 at 17:50
  • Only if there is something else open which doesn't have an Alt+I shortcut. On the desktop it does nothing. – Jamie Bull Jan 23 '13 at 18:05

Unfortunately, those shortcuts don't work anymore, no idea, why.

However, instead

  1. Select row: Ctrl-Space or Select column: Shift-Space
  2. Insert:Ctrl-S+)

will also do the job almost as quick.

The good thing about this approach is that you can vary it depending on your needs, e.g.

  • To delete row/column: Ctrl-- as second step
  • To insert multiple columns/rows: use Shift and arrow keys after step 1 to enhance selection
  • To move/copy rows columns: select columns/rows to move as in step 1 and step above, then press Ctrl-X or Ctrl-C, then proceed with step 1. & 2. in the new target range
  • As I said, they worked for me too then stopped. These other shortuts are useful but don't answer the question. – Jamie Bull Jan 24 '13 at 22:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.