View Single Post
  #1   Report Post  
sumesh56 sumesh56 is offline
Senior Member
 
Posts: 118
Default how to delete some rows without data which comes in between rows with data

i have a worksheet in which there are data in some rows say in every fifth or sixth rows. the in between rows are blank. now i want to delete those blank rows. how can i accomplish this task in a single step?