Inserting Multiple Rows in Google Docs – Spreadsheet

Posted on 2011.09.15 by Jose Ibarra

Google recently upgraded their docs interface and they made big improvements within Google Docs.  I have always been comfortable with their word processor, but recently I decided to take the plunge and begin using their spreadsheet doc.

Things seemed to be a bit streamlined and I was okay with the clean, simple interface.  My biggest challenge was inserting multiple rows.

Clicking on every menu, right-clicking on single rows,  or trying the traditional ctrl + did not do the trick.  It is a little cumbersome, but here is how I got around this annoyance:

This what Google gives you by default:

insert single row above or below

After all my cutting and pasting, I decided to highlight multiple rows, this did not work. What you need to do is highlight the row numbers (headers?) and not the actual rows.  Once they are highlighted, right-click on the row numbers column and you will see the menu change, like so:

multiple row inserts google docs

Although this is a bit clunky, it did resolved my issue of adding one row at a time.  I really hope Google brings shortcut support to this little, yet important task.

Leave a Reply