GG
Thanks for the input. I tried your suggestion with mixed results.
Sometimes it deletes only the visible rows, but not always. Do you have to
click "visible cells only" every time you want to delete the visible cells?
I'm hoping there is a fix that does not require the extra steps to
"F5..special...visible cells only." It seems strange that an upgrade from
2003 to 2007 would require so much extra effort to delete filtered rows.
Jeff

"GG" wrote:

After highlighting the rows hit F5...special...visible cells only...Ok. then
rightclick with the selection on and chose delete.

"JDOlson" wrote:

I recently switched from Excel 2003 to Excel 2007. The process described
below worked in Excel 2003, but has not worked for me in Excel 2007.

After filtering records, I highlight the rows I want to delete, then
"right-click" and "delete rows." In addition to the highlighted rows being
deleted, the non-filtered (hidden) rows which are found after my first
highlighted row, and before the last hightlighted row, are also deleted.

For example, assume there are 50 populated rows. Using autofilter, rows 5,
17 and 20 are visible. I highlight rows 5, 17 and 20, then delete these
rows. The result is that rows 5 through 20 are all deleted, not just rows 5,
17 and 20.

Is there a default setting in Excel 2007 that controls for this change?

I am using Micorsoft Office Excel 20070 (12.0.6300.5000) SP1 MSO
(12.0.6213.1000)

Thanks!
Jeff


"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.