How do I delete rows with negative values all at once i.e. 47,000.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel and need to delete at least 47,000 rows with negative values
in them all at once - Can this be done?
 
Jean,

Yes. You can do it manually: Sort based on the column of values where the negative might be found,
then select the cells with negative numbers and delete the rows.

Or you could use a macro to do essentially the same thing. Just don't write a macro that steps
through row by row....

HTH,
Bernie
MS Excel MVP
 
If the negative values all appear in the same column, you can do this easily
with filters. Select your entire table. Then, from the menu bar, Data >
Filter > AutoFilter. Click the drop-down in the column that has the negative
values and select Custom. In that dialog, choose 'is less than' '0' and
click OK. Now only the rows to be deleted should be visible.
Select (click in) a cell in the first such row, and ctrl + shift + down
arrow. Now all the cells with the negative values will be selected. Back to
the menu bar: Edit > Delete Row.
Now just turn off the filter: Data > Filter > AutoFilter.
HTH. --Bruce
 
Back
Top