Here's the problem I'm having with Excel 2007. As a simple example I have
column of numbers from 1 to 10. I apply the auto filter and de-select the
number 2, then I highlight the results and delete rows so that only the
number 2 should be remaining when I turn off the filter. The 2 has been
deleted along with the other numbers. I didn't have this problem with Office
2003.

Is this a bug?

Thanks,
Dennis