View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
this would require VBA or you may try the following procedure
in B1 put the following formula:
=MOD(ROW(),2)
and copy this down for all rows.
Now apply an autofilter and filter out every 1 or 0 and afterwards delete
the filtered rows

--
Regards
Frank Kabel
Frankfurt, Germany

Darren wrote:
I have a rather large document where I need to delete every other line
beginning with line 8. I am looking for a shortcut rather than
manually deleting each line.