autofilter not working

  • Thread starter Thread starter Guest
  • Start date Start date
Has the file you are working on had 'protection' assigned? This is the only
situation I can simulate where the autofilter is greyed out. Select a New
Excel worksheet and see if the autofilter is available. It should be and
confirms this function is working on your pc. To check if the worksheet has
'protection' just click on the tools menu and selet Protection if it says
unprotect you know it has protection and that would explain the fact
autofilter is not available on this worksheet.
 
Have you selected more than one worksheet?

Do you see [Group] in the title bar?

Right-click on a sheet tab and "ungroup" or just click on any tab but the active
sheet.


Gord Dibben MS Excel MVP
 

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

Autofilter Problem 2
2007 excel autofilter change back to 2003 autofilter? 1
excel 2007 autofilter change to 2003 autofilter functionality? 1
AUtofiltering dates 1
autofilter 4
autofilter linked in different worksheets 2
autofilter fails, not because of blank row 5
MS Excel 2003 - Autofilter for protected cells 1

Back
Top