Keyboard Shortcut Excel to Add Rows

There is no easy built-in keyboard shortcut in Excel for adding rows.  There are a couple of ways to work around this limitation:
  1. Record a macro.
  2. 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).

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.