Excel Auto Filter - cannot turn off.

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?
 
N

Nick Hodge

Kathleen

Try unfreezing the panes? (Window>Unfreeze pane)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
J

Jan Karel Pieterse

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
 

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