Home

Excel Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-683092%22%20slang%3D%22en-US%22%3EExcel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683092%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20not%20sure%20if%20there%20is%20even%20a%20formula%20that%20will%20do%20this%20for%20me.%20I%20have%20an%20existing%20spreadsheet%20and%20I%20need%20to%20enter%205%20rows%20in%20between%20each%20existing%20row.%20My%20current%20spreadsheet%20is%20already%20about%2010%2C000%20rows%20and%20I%20do%20not%20want%20to%20have%20to%20manually%20insert%205%20rows%20between%20each%20row.%20That%20will%20take%20forever.%20Can%20anyone%20help%20me%20and%20explain%20a%20better%20option%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687625%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358172%22%20target%3D%22_blank%22%3E%40Cgeddes%3C%2FA%3E%26nbsp%3BHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ECommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Cgeddes
Occasional Visitor

Im not sure if there is even a formula that will do this for me. I have an existing spreadsheet and I need to enter 5 rows in between each existing row. My current spreadsheet is already about 10,000 rows and I do not want to have to manually insert 5 rows between each row. That will take forever. Can anyone help me and explain a better option?

1 Reply

@Cgeddes Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Related Conversations
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies