View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Permanently delete filtered records

Important Reiteration:
The method I described deletes the VISIBLE filtered cells.
To delete the hidden rows, you'd need to alter the filter so only the rows
to be deleted display.
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

After you filter the records (using either AutoFilter or Advanced Filter)

Select from the first filtered record down through the last
(Do not select the data headings)

Then, from the Excel main menu:
<edit<delete....your only option will be to delete entire rows.
Click [OK] and only the visible filtered rows will be deleted.

<data<filter<show all will redisplay the hidden rows

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Allen" wrote:

I want to filter records in excel and then permanently delete the records
that have been filtered out. Any ideas? Thanks.