I'm having the strangest problem. I've never encountered it before, and I spend a lot of time working in Excel.

This is happening on the fresh install of Excel 2007 on my new Thinkpad. When I autofilter data, and then select the rows I've displayed, and delete them, Excel deletes all the hidden rows inbetween.

I can't understand why this is happening, but it's a huge problem. I do this thoughtlessly all the time. Is there a setting I need to change or something I could be missing?

Any thoughts are desperately appreciated.