How to Delete Every other row

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

G'Day;

I was given a workbook with everyother line unpopulated.
5000 lines. Is thier a way to delete evey other line other
than manually..?

Thank you.
 
Select the sheet, press F5, click special, select blanks,
click OK. Do edit>delete, select entire row.
You might want to do this on a backup copy though
 
Thank you PS, It worked like a charm......and I learned a
function ta the same time.sweet.....

Lou
 
Back
Top