Hello,

Let's say I have data in column A and different data in column H. I select the area in column A and click the Filter button on the Data tab, Sort & Filter group. The filter then works. Then, I need to filter the data in column H using different criteria. However, the Filter button is already pressed down – if I click it again, the filter in column A disappears. How can I filter the data in column H?

I'm using Excel 2007.


Pekka