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.
How would you create a shortcut key (e.g., Ctrl+Shift+J) to highlight the current row and insert a new row?
Looks like Shift+Space highlights the current row.