Select Between and in the Custom AutoFilter dialog window, notice that Excel has already added the conditions for this filter. All you have to do is select the dates from the drop-down lists, such as: ...

When you want to filter all of the rows, the Select All option will apply the filter to your entire Excel table. Examples of filters for sorting text entries include Sort A to Z and Sort by Color.

If the Grouping Dates option in the AutoFilter menu is not enabled, then you will not have the ability to group Excel date filters by months. Let us explain what you need to do. Navigate to the ...

The Custom AutoFilter window pops up. Select "Does not equal" in the "Show Rows Where" drop-down box and type "0" in the box next to it. Click "OK" to filter the Excel data.

To apply an AutoFilter, you select the column headings in A1:F1 and choose AutoFilter from the Data menu. In Excel 2007 and 2010, click the Data menu and then click Filter in the Sort & Filter group.