- Record a macro.
- Select the row that you want to insert another one on top of and by hitting SHIFT-SPACEBAR and then hit CTRL-SHIFT-PLUS (not the 10-key plus but the =/+ button).
There is no easy built-in keyboard shortcut in Excel for adding rows. There are a couple of ways to work around this limitation:
Widget by Bloggers University
Filed under: Excel