SOLVED
Home

Inserting multiple rows

%3CLINGO-SUB%20id%3D%22lingo-sub-634625%22%20slang%3D%22en-US%22%3EInserting%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-634625%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20this%20is%20a%20very%20basic%20question%20but%20I%20can't%20find%20the%20answer%20in%20the%20documentation.%20I%20often%20want%20to%20insert%20a%20bunch%20of%20rows%20at%20a%20time.%20Currently%20I%20just%20do%20it%20one%20at%20a%20time%20but%20I%20would%20like%20to%20do%20something%20like%20insert%2010%20rows%20or%20more%20all%20at%20once%20in%20an%20existing%20sheet.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-634625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-635765%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-635765%22%20slang%3D%22en-US%22%3ESelect%20the%20appropriate%20number%20of%20cells%20below%20the%20cell%20you%20want%20to%20insert%20rows.%20Press%20Ctrl%2BPlus%20sign%20(%2B)%2C%20then%20press%20R%2C%20and%20click%20OK.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-638806%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-638806%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%20Thanks%2C%20that%20seems%20to%20work%20for%20inserting%201%20row%20but%20what%20I%20was%20wondering%20is%20if%20there%20is%20a%20way%20to%26nbsp%3B%20insert%20more%20than%20one%20row%20at%20a%20time%3F%26nbsp%3B%20%26nbsp%3BI'm%20using%20the%20spreadsheet%20to%20model%20a%20simulation%20where%20each%20row%20is%20an%20event%20in%20the%20simulation%20and%20then%20I%20have%20summary%20statistics%20below%20the%20last%20row%20in%20the%20simulation.%20As%20I'm%20fleshing%20out%20the%20simulation%26nbsp%3B%20I%20want%20to%20add%20a%20bunch%20more%20rows%20below%20the%20current%20last%20row%20and%20above%20the%20summary%20statistics.%20Rather%20than%20doing%20insert%20one%20row%2020%20times%20I%20would%20like%20(if%20possible)%20to%20insert%2020%20rows%20all%20at%20once.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-638893%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-638893%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3BSorry%2C%20I%20was%20being%20dense.%20Now%20I%20get%20it.%20When%20I%20select%20multiple%20rows%20it%20inserts%20the%20same%20number%20of%20rows%2C%20that's%20what%20I%20needed%2C%20thanks%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-642556%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-642556%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20welcome.%3C%2FLINGO-BODY%3E
mdebellis
New Contributor

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. 

4 Replies
Solution
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. 

@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.

You’re welcome.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies