Deleting rows containing common data

G

gcotterl

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"
 
J

Jason Morin

One way:

1. Select the range and apply an AutoFilter (Data > Filter
AutoFilter)
Click to expand...
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
 
Top