Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Visible Rows
If I filter a list, the records that do not meet that criteria are hidden.
The hidden records are the records I want to keep. If I select the visible rows or records and right click to delete them, will all of the hidden records return when I view all records in the list? In terms of training, would it be "safer" to teach users to sort by that criteria so that the records are together, and then delete those records? Is there a function that allows you to filter and select at the same time in order to accomplish deleting certain records from the list? This question almost seems backwards to me. For example, an even better approach would be to do an advanced filter on what you want to another file so that you retain the original list somewhere. -- Thanks. Confused |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Visible Rows
Under Data-Filter there is Advanced Filter that allows you to filter
matching rows to a new location. The difference is that you have to create & use a Criteria range, rather than the filter dropdowns, so it is a little more work initially. If you wanted to filter an Address database on the ZIP column, you would copy the ZIP header to an empty spot on your sheet and immediately below the ZIP header enter the desired ZIP. For multiple ZIPs use multiple rows. Then use the Advanced filter, indicate the Criteria range, check Copy to a new location, and indicate where that should be. For more complex criteria see the help file "Confused" wrote: If I filter a list, the records that do not meet that criteria are hidden. The hidden records are the records I want to keep. If I select the visible rows or records and right click to delete them, will all of the hidden records return when I view all records in the list? In terms of training, would it be "safer" to teach users to sort by that criteria so that the records are together, and then delete those records? Is there a function that allows you to filter and select at the same time in order to accomplish deleting certain records from the list? This question almost seems backwards to me. For example, an even better approach would be to do an advanced filter on what you want to another file so that you retain the original list somewhere. -- Thanks. Confused |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Visible Rows
Thanks. I do know how to do an advanced filter, but I was wondering if you
know the answer to my questions about deleting visible rows? -- Thanks. Confused "Duke Carey" wrote: Under Data-Filter there is Advanced Filter that allows you to filter matching rows to a new location. The difference is that you have to create & use a Criteria range, rather than the filter dropdowns, so it is a little more work initially. If you wanted to filter an Address database on the ZIP column, you would copy the ZIP header to an empty spot on your sheet and immediately below the ZIP header enter the desired ZIP. For multiple ZIPs use multiple rows. Then use the Advanced filter, indicate the Criteria range, check Copy to a new location, and indicate where that should be. For more complex criteria see the help file "Confused" wrote: If I filter a list, the records that do not meet that criteria are hidden. The hidden records are the records I want to keep. If I select the visible rows or records and right click to delete them, will all of the hidden records return when I view all records in the list? In terms of training, would it be "safer" to teach users to sort by that criteria so that the records are together, and then delete those records? Is there a function that allows you to filter and select at the same time in order to accomplish deleting certain records from the list? This question almost seems backwards to me. For example, an even better approach would be to do an advanced filter on what you want to another file so that you retain the original list somewhere. -- Thanks. Confused |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Visible Rows
If you filter and copy to a new location then whatever you filter won't be
included just the same way as you copy visible cell from autofilter and copy and paste. And if you delete visible rows the hidden rows will not be deleted. What Duke explained to you when he answered this part This question almost seems backwards to me. For example, an even better approach would be to do an advanced filter on what you want to another file so that you retain the original list somewhere. yes you can use advanced filter, you need to start the filter in the workbook/sheet where you want the new list http://www.contextures.com/xladvfilter01.html#ExtractWs -- Regards, Peo Sjoblom "Confused" wrote in message ... Thanks. I do know how to do an advanced filter, but I was wondering if you know the answer to my questions about deleting visible rows? -- Thanks. Confused "Duke Carey" wrote: Under Data-Filter there is Advanced Filter that allows you to filter matching rows to a new location. The difference is that you have to create & use a Criteria range, rather than the filter dropdowns, so it is a little more work initially. If you wanted to filter an Address database on the ZIP column, you would copy the ZIP header to an empty spot on your sheet and immediately below the ZIP header enter the desired ZIP. For multiple ZIPs use multiple rows. Then use the Advanced filter, indicate the Criteria range, check Copy to a new location, and indicate where that should be. For more complex criteria see the help file "Confused" wrote: If I filter a list, the records that do not meet that criteria are hidden. The hidden records are the records I want to keep. If I select the visible rows or records and right click to delete them, will all of the hidden records return when I view all records in the list? In terms of training, would it be "safer" to teach users to sort by that criteria so that the records are together, and then delete those records? Is there a function that allows you to filter and select at the same time in order to accomplish deleting certain records from the list? This question almost seems backwards to me. For example, an even better approach would be to do an advanced filter on what you want to another file so that you retain the original list somewhere. -- Thanks. Confused |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Visible Rows
Thanks for the answer!
-- Thanks. Confused "Peo Sjoblom" wrote: If you filter and copy to a new location then whatever you filter won't be included just the same way as you copy visible cell from autofilter and copy and paste. And if you delete visible rows the hidden rows will not be deleted. What Duke explained to you when he answered this part This question almost seems backwards to me. For example, an even better approach would be to do an advanced filter on what you want to another file so that you retain the original list somewhere. yes you can use advanced filter, you need to start the filter in the workbook/sheet where you want the new list http://www.contextures.com/xladvfilter01.html#ExtractWs -- Regards, Peo Sjoblom "Confused" wrote in message ... Thanks. I do know how to do an advanced filter, but I was wondering if you know the answer to my questions about deleting visible rows? -- Thanks. Confused "Duke Carey" wrote: Under Data-Filter there is Advanced Filter that allows you to filter matching rows to a new location. The difference is that you have to create & use a Criteria range, rather than the filter dropdowns, so it is a little more work initially. If you wanted to filter an Address database on the ZIP column, you would copy the ZIP header to an empty spot on your sheet and immediately below the ZIP header enter the desired ZIP. For multiple ZIPs use multiple rows. Then use the Advanced filter, indicate the Criteria range, check Copy to a new location, and indicate where that should be. For more complex criteria see the help file "Confused" wrote: If I filter a list, the records that do not meet that criteria are hidden. The hidden records are the records I want to keep. If I select the visible rows or records and right click to delete them, will all of the hidden records return when I view all records in the list? In terms of training, would it be "safer" to teach users to sort by that criteria so that the records are together, and then delete those records? Is there a function that allows you to filter and select at the same time in order to accomplish deleting certain records from the list? This question almost seems backwards to me. For example, an even better approach would be to do an advanced filter on what you want to another file so that you retain the original list somewhere. -- Thanks. Confused |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide a visible rows | Excel Discussion (Misc queries) | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
Using COUNTIF with visible rows only | Excel Worksheet Functions | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
How do I limit the visible rows in Excel? | Excel Discussion (Misc queries) |