=IF(MOD(ROW(),6)=0,"",OFFSET(A$1,ROW()-1-INT((ROW()-1)/6),0))
does it on Col A when entered in Col B.


"Yogibear" wrote:

I have an extremely large excel spreadsheet, filled with names and addresses,
which is 5 rows, to make the spreadsheet more readable, i would like to
insert a line every five rows. Is this possible, with out doing it manually.