Add/delete multiple rows in Goolge Sheets

For adding multiple rows in Google Sheets: Add 8 rows at once 1. Choose how many rows you want to add. In my example I chose eight rows. Add 8 rows at once in Google Sheets 2. Right click and it gives you a choice to add above or below. Right click and it gives you a choice to add above or below 3. I chose below and voila - it is done! Add 8 rows at once in Google Sheets You can you use the same technique for deleting rows and adding-deleting columns. Here is an animated gif of the full process: Add 8 rows at once in Google Sheets