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

excel用宏如何筛选日期

icondynamic

Over on the Contextures website, I've updated the AutoFilter Intro page, so it now covers the basics for Excel 2007 AutoFilters.

在Contextures网站上,我已经更新了AutoFilter Intro页面,因此现在它涵盖了Excel 2007 AutoFilters的基础。

However, many people are still using an older version of Excel, so I've moved the original material to the Excel 2003 AutoFilter Basics page.

但是,许多人仍在使用旧版本的Excel,因此我已将原始资料移至“ Excel 2003 AutoFilter基础”页面。

AutoFilters are easier to use in Excel 2007 and Excel 2010, and the filter and sort options are automatically added in the top row, if you format your list as an Excel Table.

如果您将列表设置为Excel Table格式,则自动筛选器在Excel 2007和Excel 2010中更易于使用,并且筛选器和排序选项会自动添加到第一行。

筛选动态日期范围 (Filter for Dynamic Date Ranges)

Among the new AutoFilter features that were introduced in Excel 2007 are dynamic date ranges. A Dynamic Date Range is one that changes automatically, as time moves forward. For example, you could select

动态日期范围是Excel 2007中引入的新自动筛选功能。 动态日期范围是随着时间的推移自动更改的范围。 例如,您可以选择

Yesterday, which will represent a different date, every day that you open the Excel file.

昨天 ,您打开Excel文件的每一天都代表不同的日期。

Excel2007AutoFilterDates

Unfortunately, the dynamic dates are only semi-dynamic, and they don't magically change when you open the workbook at a later date. You'll need to update the filter to see the current information.

不幸的是,动态日期只是半动态的,以后您打开工作簿时,它们不会发生神奇的变化。 您需要更新过滤器以查看当前信息。

You can update the Excel 2007 AutoFilter manually, by clicking Reapply on the Excel Ribbon. Or, you could add a bit of code to the Workbook_Open event, to reapply the filters automatically.

您可以通过在Excel功能区上单击“重新应用”来手动更新Excel 2007自动筛选。 或者,您可以向Workbook_Open事件添加一些代码,以自动重新应用过滤器。

autofilter2007_16

了解有关Excel 2007自动筛选的更多信息 (Learn More About Excel 2007 AutoFilters)

If you're not familiar with the new features in Excel 2007 and Excel 2010 AutoFilters, you can learn more at Excel 2007 AutoFilter Basics. _____________

如果您不熟悉Excel 2007和Excel 2010 AutoFilters中的新功能,则可以在Excel 2007 AutoFilter Basics中了解更多信息。 ______________

翻译自: https://contexturesblog.com/archives/2010/12/08/excel-2007-autofilter-dynamic-dates/

excel用宏如何筛选日期

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值