how can i insert a row every five lines in excel

Y

Yogibear

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.
 
E

Evan

=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.
 
Top