excel用宏如何筛选日期_Excel自动筛选宏

excel用宏如何筛选日期

There are two types of AutoFilters in Excel – worksheet AutoFilters, and List (Table) AutoFilters. If you're using Excel AutoFilter macros, be sure they're designed for the type of Autofilters that are in your workbook.

Excel中有两种类型的自动筛选器：工作表自动筛选器和列表(表)自动筛选器。 如果您使用的是Excel自动筛选器宏，请确保它们是为工作簿中的自动筛选器类型设计的。

Excel自动筛选 (Excel AutoFilters)

In Excel, if you have a range of cells with a heading row, and rows with data, you can use the AutoFilter feature.

在Excel中，如果您具有一个带有标题行的单元格区域，以及带有数据的行，则可以使用“自动筛选”功能。

There are basic instructions, and a few AutoFilter tricks and tips on my Contextures website.

我的Contextures网站上有基本说明以及一些自动筛选技巧和提示 。

工作表自动筛选 (Worksheet AutoFilters)

In the olden days of Excel, there was only one type of AutoFilter – a worksheet AutoFilter.

在过去的Excel中，只有一种类型的AutoFilter-工作表AutoFilter。

And to add to our suffering in the olden days, you could only have one worksheet AutoFilter on each sheet. I know, it was rough!

为了增加我们过去的痛苦，每张纸上只能有一个工作表“自动筛选”。 我知道，这很艰难！

You can still use worksheet AutoFil