Is there a keyboard shortcut for 'Insert table row above/below' on the ribbon in Excel 2013

Question

I'm trying to add a row to a table (created via Format as Table), but the only way I can see to do so is via Right clicking (or using the menu keyboard key).

Is there a keyboard shortcut similar to the ones that access the ribbon (Alt->N->...)?

Solution 1

There isn't an "insert table row below" shortcut by default, but you can create one:

1. Click the Customize Quick Access Toolbar icon at the top of the Excel window.

   

2. Click More Commands....

   

3. The Excel Options dialog opens to the Quick Access Toolbar page. Under Choose commands from:, select All Commands.

   

4. Double-click Insert Table Row Below, then click OK.

   

5. Insert Table Row Below should now show up in the Quick Access Toolbar at the top of your Excel window. Press Alt to see its shortcut number. In the screenshot, its number is 7, so its keyboard shortcut is Alt+7. The number (and keyboard shortcut) will be different for you if there's a different number of commands on your quick access toolbar.

   

Solution 2

To add a row you can use Ctrl+Shift++ at the same time on the main keyboard or just Ctrl-+ on numeric pad

And to remove a row Ctrl+- also at the same time

Comments

[phuclv]

obviously a key combination is supposed to be pressed at the same time. And the shortcut is just Ctrl-+, it's just that the + symbol is pressed as Shift+= in the US keyboard, so when you press Ctrl-Shift-= you get Ctrl-+

[Murtaza Haji]

This adds row above the selected row. What is the shortcut to add row below selected column?