View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tinkerbell1178 Tinkerbell1178 is offline
external usenet poster
 
Posts: 3
Default Automatically delete blank rows

I need to delete every second row in my spreadsheet - the rows are blank.
There are 30,000 rows so I don't want to do it manually - is there an easy
way to delete every second (or every blank) row?