software

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 MVPquot;Jeanquot; gt; wrote in message
...
gt;I am using Excel and need to delete at least 47,000 rows with negative values
gt; in them all at once - Can this be done?
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 gt;
Filter gt; 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 gt; Delete Row.
Now just turn off the filter: Data gt; Filter gt; AutoFilter.
HTH. --Bruce

quot;Jeanquot; wrote:

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