Create shortcut key to insert new row using Excel 2010
- by Dave Jarvis
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.
