Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Is there a way to do this without using the menu?

I have seen references to ctrl + space and ctrl + +, but this no longer works (zooms in and out in Google Chrome)

share|improve this question

5 Answers 5

While it's not directly possible in the current version with its own keystroke, there is another very simple way to accomplish this.

First, be located in the row on which you want to insert a row above or below.

Then do the following (keys are on Mac, so translate as necessary for your OS):

  1. Ctrl + Option + I - invokes the Insert menu
  2. Then hit the R key for Row Above, or the W key again for Row Below

I guess this way may actually be one less keystroke than how it was done before, so that's a win right there!

Alternatively, you can also just use your cursor keys (to me this is easier, even if it's more keystrokes):

  • (down arrow once) for Row Above
  • (down arrow twice) for Row Below
  • Hit (Enter).

Hope this helps!

share|improve this answer
    
What is mean by Option in step 1? –  shylendra Nov 5 at 11:23

For Windows laptop users, the shortcut is to highlight the whole row by pressing Shift+Space (or highlight the whole column by Ctrl+Tab) and press the context-menu key (which is usually located next to the Ctrl key) on your keyboard and then press "Insert 1 Below" / "Insert 1 Above" (or "Insert 1 Left" / "Insert 1 Right" for inserting a column).

share|improve this answer

Chrome (Windows, Linux):

ALT+I, then R

IE & Firefox (Windows, Linux):

ALT+SHIFT+I, then R

Mac:

CTRL+OPTION+I, then R


This will add a row above.

Instead of R you can use...

  • W to add row below
  • C to add column to the left
  • G to add column to the right
share|improve this answer

Try this: Ctrl+I then R.

This will insert a new row below.

share|improve this answer

On Windows:

Press Alt+b+b This inserts a row below.

Press Alt+b+a This inserts a row above.

share|improve this answer
    
-1; Hi Helper, I tried it but without success. Btw, how can I type the first key combination? –  Jacob Jan Tuinstra May 20 at 9:35
    
This worked for me, Alt + b, b or Alt + b, a –  mbdavis Nov 16 at 19:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.