how can i insert a row every five lines in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I insert a row after every row of data in XL? 5
Links error when insert line/row to source workbook 1
printing mailing labels when data is in rows 3
Macro to insert a row after every 4th row 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Adding five new rows every 40 rows in a spreadsheet? 8
Deleting extra rows in Excel 07 2
excel macro/funcion insert row if 1

Back
Top