Forum Discussion
Inserting multiple rows
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.
- Select the appropriate number of cells below the cell you want to insert rows. Press Ctrl+Plus sign (+), then press R, and click OK.
7 Replies
- Select the appropriate number of cells below the cell you want to insert rows. Press Ctrl+Plus sign (+), then press R, and click OK.
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
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.
