OK, I'm assuming you really mean Clear the data and not Delete the row.

Assuming your data is in say A1:G1000, in cell H2 put the following formula
and copy down:-

=MOD(ROW(),2)

In cell H1 put a title eg FilterMe

Select H1:H1000 and do data / filter / autofilter and filter on whatever
number (0 or 1) appears against the rows you wish to clear.

Now select all your data and do Edit / Go To / Special / Visible cells only,
then hit delete. Now unfilter.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"ChuckF" wrote in message
oups.com...
Whoops...it actually is the entire row. I want to keep row 1 but clear
the data from row 2, keep 3 clear the data from 4...so on and so on.