HELP!! Auto Filter Locked!

M

Marisa

I finished creating a huge database and had been using the Auto Filter to
help me plug in data and analyze it. When I finished in the particular column
I was working on, the black arrow that appears when you turn the feature on,
had turned blue and now I can't Auto Filter anything in the entire
spreadsheet. If you have any advice please let me know as I don't want to
have to recreate this entire thing
 
S

ShaneDevenshire

Hi Marisa,

You mean by the black arrow turns blue that the filter dropdown has a blue
triangle? This means that that filter is active. Choose Data, Filter, Show
All and your filters should be active again.
 

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 - auto filter freezes 2
Auto Filter - It's broken! Help! (Office '03) 2
auto filter on columns 2
Filters do not work correctly for table linked to an Access query 1
Turning Off an Advanced Filter 1
Auto Filter Single Column 2
Excel Auto Filter - cannot turn off. 2
Auto-Scale 2

Top