Deleting rows containing common data
 

I have an Excel 2000 spreadsheet with 30,000 rows. The rows look like this:

007-007
68-4611
68-4682
total
007-007
total
007-007
28-4831
68-2454
68-4682
total
007-007
28-4831
68-2454
68-4682
total
007-007
28-4831
68-2454
68-4682
total
007-007
68-4682
total
007-007
68-4682
total


How do I delete the rows containing "total"

One way:

1. Select the range and apply an AutoFilter (Data Filter
AutoFilter)
2. On the drop-down list, select "Total".
3. Select the range again if needed.
5. Press F5 Special and click "Visible Cells Only."
6. Remove the filter the same way it was applied.
7. Press <Ctrl<-.
8. Click on "Entire row".

HTH
Jason
Atlanta, GA

-----Original Message-----
I have an Excel 2000 spreadsheet with 30,000 rows. The
rows look like this:

007-007
68-4611
68-4682
total
007-007
total
007-007
28-4831
68-2454
68-4682
total
007-007
28-4831
68-2454
68-4682
total
007-007
28-4831
68-2454
68-4682
total
007-007
68-4682
total
007-007
68-4682
total


How do I delete the rows containing "total"

.