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
Highlighted
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
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies