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.
8 Replies
Okay, so, I don't know if you have your answer already, and I could be misinterpreting your question entirely, but I figured out that (if you're on Windows) you can select a row (the amount of boxes you select horizontally matters!) and then press Ctrl + Shift and hover over the little green box in the bottom. Your cursor should transform into a little bar with arrows that point both up and down! Then you drag that double arrow(?) thing down for the amount of rows you want, and it'll insert them.
Hope this helps!
- 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.
