Thanks for the input, Ron. My version of Excel 2007 does not have an "Edit"
dropdown menu. I've tried "right-clicking" the rows as you describe, but the
hidden rows are also deleted. Do you have any other suggestions?
Jeff

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