Permanently delete filtered records
Thanks, but I want to delete the HIDDEN records and keep the visible ones;
sorry for not being clearer. Is there a way to do that?
Allen
"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.
|