Home

Adding rows in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-754460%22%20slang%3D%22en-US%22%3EAdding%20rows%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754460%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20adding%20rows%2C%20I%20right%20click%20the%20left-hand-side%20end%20of%20the%20row%20and%20select%20%22Insert%22.%26nbsp%3B%20This%20inserts%20one%20row.%26nbsp%3B%20I%20then%20have%20to%20do%20this%20many%20times%20to%20insert%20more%20rows.%26nbsp%3B%20Is%20there%20a%20way%20to%20ask%20it%20to%20insert%2C%20say%2C%2020%20rows%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-754460%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754469%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20rows%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754469%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376342%22%20target%3D%22_blank%22%3E%40Sally1959%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%2020%20rows%20starting%20at%20the%20row%20where%20you%20want%20to%20insert%2C%20then%20press%20Ctrl%2BPlusSign%2C%20R%2C%20and%20click%20OK.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754482%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20rows%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754482%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%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%3BI%20just%20tried%20that%20but%20all%20it%20did%20was%20put%20an%20%22r%22%20in%20the%20first%20cell%20in%20the%20row!%26nbsp%3B%20Must%20be%20doing%20it%20wrong.%26nbsp%3B%20I%20hightlighted%20some%20rows%2C%20pressed%20Cntrl%20and%20%2B%20simultaneously%20then%20pressed%20%22r%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754536%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20rows%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376342%22%20target%3D%22_blank%22%3E%40Sally1959%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ER%20means%20select%20entire%20row%20in%20the%20Insert%20dialog%20box.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754539%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20rows%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754539%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%3BJust%20tried%20selecting%20several%20rows%2C%20pressed%20Ctrl%2BShift%2Bplussign%20and%20it%20inserted%20that%20number%20of%20rows!%26nbsp%3B%20Didn't%20need%20to%20use%20%22R%22.%26nbsp%3B%20Thanks%20-%20got%20there%20in%20the%20end!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Sally1959
Occasional Contributor

When adding rows, I right click the left-hand-side end of the row and select "Insert".  This inserts one row.  I then have to do this many times to insert more rows.  Is there a way to ask it to insert, say, 20 rows?

Thanks

4 Replies

@Sally1959 

Select 20 rows starting at the row where you want to insert, then press Ctrl+PlusSign, R, and click OK.

Thanks @Twifoo I just tried that but all it did was put an "r" in the first cell in the row!  Must be doing it wrong.  I hightlighted some rows, pressed Cntrl and + simultaneously then pressed "r"?

@Sally1959 

R means select entire row in the Insert dialog box.

@Twifoo Just tried selecting several rows, pressed Ctrl+Shift+plussign and it inserted that number of rows!  Didn't need to use "R".  Thanks - got there in the end!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 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