AutoFilter Problem

D

Dennis

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
 
S

ShaneDevenshire

Hi,

It is working correctly for me. The same in both 2003 and 2007. However,
if you are having a problem you can select all the data after you apply the
Auto Filter and press F5, Special, Visible cells only, click OK and press
Ctrl - (Ctrl and the minus key) respond Entire Row. Now turn off the Auto
Filter and the 2's should still be there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top