delete alternate rows in ms excel?

Question

how to delete alternate rows in ms excel?

I've got 10000 rows....deleting it manually will take time...

Answer 1

What is in these alternate rows? Are they blank?

If they are blank, you could sort your file on a field which is filled on every applicable row of a particular column (like Lastname).

All the blank rows, with no data in that field would go to the end of file where you could select and delete them.

If, however, you have some sort of data in the alternate rows, you are stuck - unless they contain a unique piece of data on which you could sort.

Answer 2

Sub DeleteEmptyRows() Dim Counter Dim i As Integer selection("A1").elect Counter = InputBox("enter the finished form of rows to technique") ActiveCell.elect For i = a million To Counter If ActiveCell = "" Then determination.EntireRow.Delete Counter = Counter - a million Else ActiveCell.Offset(a million, 0).elect end If next i end Sub

Answer 3

In Excel choose the Letter ie) E and it highlights the whole row of contents in E. now if you hold your shift key down and select all letter ie) EFG, Right click Clear Contents.