Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete rows with negative values all at once i.e. 47,000.
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete rows with negative values all at once i.e. 47,000.
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 "Jean" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete rows with negative values all at once i.e. 47,000.
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 "Jean" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ignore negative values when adding | Excel Discussion (Misc queries) | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Want to delete rows | Excel Discussion (Misc queries) | |||
how do i prevent a #REF! error when i delete non adjacent rows? | Excel Worksheet Functions | |||
delete repeating rows | Excel Worksheet Functions |