Microsoft Office Tutorials and References
In Depth Information
Exploring Special Filters
Dynamic filters factor in today’s date when
performing the filter. For example, performing a
filter to find all invoices coming due Next Week
will produce a different result today than it will
if you perform the same filter sometime next
month. Dynamic filters include Today, Last Year,
Next Month, and even Quarter 1. Figure 8-18
illustrates the full range of date filters available
1. To create a date filter, click the filter arrow in
the column header containing the data you
want to filter and click Date Filters.
2. Select the filter that best meets your needs.
3. Enter your specific criteria in the resulting
dialog box and click OK to apply the filter.
Filtering by Time
Use the date AutoFilters in Excel to ﬁlter
by time as well. For example, to ﬁlter by
an earlier time than 8:00 in the morning,
choose the Before ﬁlter, enter 8:00 AM, and
then click OK.
Filtering by Color
If you are the type of person who likes to
colorcode your data, Excel has a filter just for you. If
your database includes colored cells or colored
fonts, the AutoFilter will include an option to
filter by color (see Figure 8-19).
Date filters in Excel 2010.
In determining the order of dates, Excel
prioritizes year, then months, then days.
January is always the first month of a
year and the first month of a quarter.
Filtering by color.