Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I delete filtered lines in Excel 2000?
I have applied a filter to a document, now I want to delete the filtered
lines. When I delete the lines it is also deleting the lines in between the filter. |
#2
|
|||
|
|||
Hi Nicola
select the filtered lines that you want to delete and then chose edit / go to / click on the special button and choose visible cells only - now delete (use edit / delete and delete the row) Please, try this on a copy of your workbook first. Cheers JulieD "Nicola H" <Nicola wrote in message ... I have applied a filter to a document, now I want to delete the filtered lines. When I delete the lines it is also deleting the lines in between the filter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) |