I know this is a very basic question but I can't find the answer in the documentation. I often want to insert a bunch of rows at a time. Currently I just do it one at a time but I would like to do something like insert 10 rows or more all at once in an existing sheet.
@Twifoo Thanks, that seems to work for inserting 1 row but what I was wondering is if there is a way to insert more than one row at a time? I'm using the spreadsheet to model a simulation where each row is an event in the simulation and then I have summary statistics below the last row in the simulation. As I'm fleshing out the simulation I want to add a bunch more rows below the current last row and above the summary statistics. Rather than doing insert one row 20 times I would like (if possible) to insert 20 rows all at once.