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