Excel Auto Filter - cannot turn off.

  • Thread starter Thread starter Kathleen
  • Start date Start date
K

Kathleen

The AutoFilter appears to be on because the arrow of one
column is blue - however rows are black,not blue,
indicating rows are not filtered. No dropdown box appears
when I click any of the AutoFilter column arrows. Rows
are missing, indicating filter is active. "Filter Mode"
appears in status bar. How do I restore all the data &
unlock the AutoFilter?
 
Kathleen

Try unfreezing the panes? (Window>Unfreeze pane)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Hi Kathleen,
The AutoFilter appears to be on because the arrow of one
column is blue - however rows are black,not blue,
indicating rows are not filtered. No dropdown box appears
when I click any of the AutoFilter column arrows. Rows
are missing, indicating filter is active. "Filter Mode"
appears in status bar. How do I restore all the data &
unlock the AutoFilter?

Have you tried data, filter, show all?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top