Thread: How do I add a line every 3 lines in a 5600 line spreadsheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default How do I add a line every 3 lines in a 5600 line spreadsheet?
in a spare column number the lines. Then Copy the contents of those
cells into the cells below in that column twice. Now sort your
spreadsheet on that column


Karen Rosenberger wrote:
I need to insert 2 blank lines between each line of data of a spreadsheet
that is approximately 5600 lines long. Any suggestions?

Reply With QuoteReply With Quote