May 22 2019 12:50 PM
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.
May 22 2019 01:23 PM
SolutionMay 23 2019 11:24 AM
@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.
May 23 2019 11:59 AM
@Twifoo Sorry, I was being dense. Now I get it. When I select multiple rows it inserts the same number of rows, that's what I needed, thanks for the help.
Jan 09 2022 07:30 PM - edited Jan 09 2022 07:32 PM
I didn't get it. The method mentioned above just inserts one row below each of the rows I have selected respectively. I'm wondering how to insert multiple rows only below exactly the row I have selected.@mdebellis
Jan 12 2022 09:56 AM
Jan 14 2022 05:55 AM
May 22 2019 01:23 PM
Solution