Adding blocks of new rows to a Google spreadsheet may confuse those coming from years of MS Excel usage who are unfamiliar with Google’s interface, however it is possible to add more than one row at a time to your Google spreadsheets.
You have probably noticed that using the Insert > Row above/Row below appends only one row at a time — quite tedious if you need dozens of extras. Fear not, for there is another button that will get the job done.
Adding multiple rows to a Google spreadsheet is done by pressing the “+” button, which is located at the bottom left corner of your spreadsheet. Click this button (pictured at right), and Google Spreadsheets will ask how many rows you wish to add.
Fill in a number, press the “OK” button, and a block of new rows will be inserted at the end of your spreadsheet.
