Excel 2007 Auto Filter disappears

J

Jason

I haven't seen this firsthand, but one of our users has reported this
happening to her several times.
Working in a spreadsheet with the columns filtered, when she makes
changes to a cell, the filters disappear. It seems to be most
consistently happening when she is deleting values from a cell. Of
course, by the time I get there to witness the issue, it doesn't
happen again.

I know Ctrl-Shift-L will toggle the filter, and my first suspicion was
that she was somehow inadvertently hitting that key combination. Since
it seems to happen more when using the [DEL] key, I was wondering if
anyone knew of another combo involving the DEL key that could remove
the auto filter?

This happen to anyone else?

Thanks,
Jason
 

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

Similar Threads

Excel 2007 : cannot shift cells in a filtered range or table 0
Excel 2007 won't recalculate unless I turn off or re-apply auto filter 0
Office 2007 programs excel and word text starts typing by itself 1
Problem with filtering columns in Excel 2007 1
Filters keep "locking up" in Excel 2003 0
Sort Ascending Using Auto-Filter Ignores First Row 1
Auto-filter by cursor location 7
Excel file keeps locking - Strange problem 0

Top