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