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: 253
        
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