| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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" |
|
#2
|
|||
|
|||
|
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" . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| how do I insert multiple rows in excel after every row of data | Excel Discussion (Misc queries) | |||
| Select all data, multiple rows | Excel Discussion (Misc queries) | |||
| how do i merge 2 rows of data into one | Excel Discussion (Misc queries) | |||
Linear Mode
