Forum Discussion

Deleted's avatar
Deleted
Sep 14, 2022

Autofilter does not show values from 2022

Excel for Mac v.16.65

 

I have a long list with dates and times in column "Datum och tid", from 2020 to 2022

 

When I use autofilter on this column, autofilter only displays the values from 2020 and 2021

 

Any idea how I can solve this? Some error in Excel that is never solved by Microsoft

 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    I suspect you have an empty row above the row where the dates from 2022 begin. Delete it and try again.

Resources