| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - How do I delete filtered out rows?
I want to quickly delete unwanted rows from a file. I can use a custom
filter to "hide" the unwanted rows, but I'd like to delete those rows. Any suggestions. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - How do I delete filtered out rows?
Instead of hiding the unwanted rows, filter to show ONLY those rows. Then
select and delete the visible rows. "rook" wrote: I want to quickly delete unwanted rows from a file. I can use a custom filter to "hide" the unwanted rows, but I'd like to delete those rows. Any suggestions. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - How do I delete filtered out rows?
You need to choose a filter option which displays only the unwanted
rows (i.e. the opposite of what you have now). Then highlight the rows which are visible and Edit | Delete Row. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define a range containing the first 10 rows of a filtered list | Excel Worksheet Functions | |||
| Not Enough Rows in Excel | Excel Discussion (Misc queries) | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| How do I delete filtered lines in Excel 2000? | Excel Worksheet Functions | |||
Linear Mode
