Right clicking on a row and clicking insert is fairly time consuming. I'd rather not have to take my hands off the keyboard. How can I insert a new row above my current row using only the keyboard? I'm primarily interested in inserting a single row at a time, but would also be interested in answers that address multiple lines at a time.
There are two options that I'm aware of, and both (unfortunately) require two steps.
- With a single cell selected, hit Shift + Space to select the row.
- Hit Control + Shift + + to insert a row above the current row.
- With a single cell selected, hit Control + Shift + + to insert a row.
- Hit Enter to accept the default of "Shift cells down."
If inserting many rows at once, I think the first option is the best, as you can repeat the second step without having to re-select the row.
I found interesting the ALT + I ,R solution, which works in the English version of Excel, at any rate.
I have been using for years the macro below, assigned to Ctrl-N (which takes over from the shortcut defined for New Workbook), but you can assign to any key combination you prefer.
Sub InsertRow() ' ' InsertRow Macro ' Macro recorded 08.08.98 by A C Rowland ' ' Keyboard Shortcut: Ctrl+n ' Selection.EntireRow.Insert End Sub
This is a terrible terrible way of doing it but I want to help out future German (or other non-English) readers reading ATG's answer. In a German Excel 2007 I could reproduce the Alt navigation via
Alt + R + I + B + Enter
So to put it more generally: press Alt and then whatever brings you to Start, then to Insert (which is very far to the right in the Ribbon), then to Insert row and then - because Microsoft apparently thinks it's a good idea to assign a letter to two options in this menu - press Enter
I never knew this menu existed there. If you did already know then this answer might seem obvious to you but it took me some digging.