Create shortcut key to insert new row using Excel 2010

Posted by Dave Jarvis on Super User See other posts from Super User or by Dave Jarvis
Published on 2012-10-31T21:36:10Z Indexed on 2012/11/05 23:05 UTC
Read the original article Hit count: 183

Tried to create a macro in Excel to insert a row:

Sub InsertRow()
'
' InsertRow Macro
'
' Keyboard Shortcut: Ctrl+Shift+I
'
    Selection.EntireRow.Insert
End Sub

However, this does not insert a new row without first manually selecting a row.

Every solution I've found requires that a row be highlighted before inserting a new row.

See also: http://www.shortcutworld.com/en/win/Excel_2010.html

How would you create a shortcut key (e.g., Ctrl+Shift+J) to highlight the current row and insert a new row?

Thank you!

Update

Looks like Shift+Space highlights the current row.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about keyboard-shortcuts