Share via

Date Filter Drop Down

Anonymous
2022-05-22T23:45:02+00:00

Which excel versions do not have the Date Filter Drop Down feature?

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. OssieMac 48,001 Reputation points Volunteer Moderator
    2022-05-23T04:57:38+00:00

    Not sure if I am correctly interpreting your problem. With AutoFilter, there are 2 methods of displaying the filter list. One is Grouped and the other a simple list of the dates.

    The above can be changed as follows.

    • Select File -> Options -> Advanced.
    • Scroll down to Display options for this workbook
    • Check or uncheck the option to Group dates in the AutoFilter menu.

    Refer to the screen shot. If this does not resolve your problem then lease explain further.

    Was this answer helpful?

    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2022-05-23T03:59:13+00:00

    As far as I remember, any version before 2016.

    EDIT: I checked my VMs and found that also Excel 2007 has this option.

    Andreas.

    Was this answer helpful?

    0 comments