+ Reply to Thread
Results 1 to 2 of 2

Insert multiple lines between each row

  1. #1
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    211

    Insert multiple lines between each row

    Is there a way to insert 4 lines after each entry in excel. So column A is just a long list of items and they want 4 lines between each one. Does anyone have a trick to do that without using VBA?

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Insert multiple lines between each row

    Paste this formula in B1 and then fill down

    =IF(MOD(ROW(),5)=1,INDEX(A:A,(ROW()-1)/5+1,1),"")
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-03-2018, 01:40 PM
  2. [SOLVED] How do I insert high-low lines on 2 specific lines (out of 4)?
    By radiotower in forum Excel General
    Replies: 0
    Last Post: 01-20-2017, 02:20 AM
  3. [SOLVED] insert multiple new lines in one go, at every second row
    By edunne in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-07-2014, 06:04 AM
  4. Userform: insert multiple lines by text value
    By shan_shan088 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2013, 04:23 AM
  5. [SOLVED] Insert blank lines to make the total number of lines 67
    By raghuprabhu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2012, 07:34 AM
  6. Replies: 0
    Last Post: 02-09-2012, 11:53 AM
  7. [SOLVED] Write code to insert multiple lines
    By Frantic Excel-er in forum Excel General
    Replies: 0
    Last Post: 06-16-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1