Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
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
    
Which Service Pack (if any!)? –  pnuts Mar 13 '13 at 14:19
add comment

1 Answer

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
share|improve this answer
    
Alt-IR and Alt-IC work for me (Excel 2007, Windows 7). –  pnuts Jan 23 '13 at 19:59
    
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
add comment

Your Answer

 
discard

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

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