Hi

One way
Create a helper column with the formula
=MOD(ROW(),2)
copy down the column
DataFilterAutofilter select the drop down on the new helper column and
select 0
Delete all the visible rows as they are the even ones.

Regards

Roger Govier



tjc wrote:

Is there a way I can delete only the even rows in my spreadsheet?

I have over 6000 rows and I only need the odd ones

Thanks