excel自动筛选_在Excel 2007中按选择自动筛选

excel自动筛选

在Excel 2007中按选择自动筛选 (AutoFilter by Selection in Excel 2007)

A couple of weeks ago I described how you could select a cell in a table, and automatically filter the list based on that cell's value. The same feature is available in Excel 2007, using a different technique.

几周前，我描述了如何在表格中选择一个单元格，并根据该单元格的值自动过滤列表 。 Excel 2007中可以使用不同的技术使用相同的功能。

Using the same example as in the previous post, the East region is selected in the table below. With a couple of clicks, and no programming, you can add an AutoFilter and filter the table to show only the East region orders.

使用与上一篇文章相同的示例，在下表中选择了东部地区。 只需单击几下，无需进行编程，就可以添加“自动筛选”并筛选表格以仅显示东部地区的订单。

应用自动筛选 (Apply the AutoFilter)

In previous versions of Excel, you had to add a toolbar button to use the filter by selection feature. In Excel 2007, the feature is available in a shortcut menu. The table doesn't need to have an AutoFilter currently applied.

在早期版本的Excel中，您必须添加工具栏按钮才能使用按选择过滤功能。 在Excel 2007中，此功能在快捷菜单中可用。 该表不需要当前已应用自动筛选。

1. In a table in Excel, right-click a cell that contains the criterion you'd like to use. For example, to filter for the East region records, right-click an East cell in the Region column.
   在Excel的表格中，右键单击包含您要使用的条件的单元格。 例如，要过滤东部区域记录，请在“区域”列中右键单击一个东部单元格。
2. On the shortcut menu, click Filter, then click Filter by Selected Cell's Value
   在快捷菜单上，单击“筛选器”，然后单击“按选定单元格的值筛选”

An AutoFilter is added to the table, if there wasn't already one in place. The table is filtered, and shows only the East region records.

如果还没有自动过滤器，则会将其添加到表中。 该表将被过滤，并且仅显示东部地区记录。

取下过滤器 (Remove the Filter)

To remove the filter, and show all the records again:

要删除过滤器，然后再次显示所有记录：

1. In the Region column heading, click the AutoFilter drop down arrow
   在“区域”列标题中，单击“自动筛选”下拉箭头
2. Click Clear Filter From "Region".
   单击“从“区域”清除过滤器”。

The filter is removed from the Region column, but the AutoFilter feature is still turned on.

过滤器已从“地区”列中删除，但“自动过滤”功能仍处于打开状态。

For more information on Excel AutoFilters, visit the pages on Excel AutoFilter Basics and Excel AutoFilter Tips on my website.

有关Excel自动筛选的更多信息，请访问我网站上的Excel自动筛选基础知识和Excel自动筛选技巧中的页面。

将值粘贴到已过滤工作表上 (Paste As Values on a Filtered Sheet)

In related news, I recently discovered that the mouse shortcut to copy and paste as values doesn't work anywhere on a filtered sheet, unless all the records are showing.

在相关新闻中，我最近发现，除非已显示所有记录，否则将鼠标复制和粘贴为值的快捷方式在已过滤工作表上的任何地方都无法使用。

Here you can see that it's not available on the shortcut menu.

在这里您可以看到它在快捷菜单上不可用。

You can use other methods to copy and paste as values, such as the Ribbon command, but not the shortcut. I wonder why.

您可以使用其他方法将其复制并粘贴为值，例如“功能区”命令，但不能使用快捷方式。 我想知道为什么。

翻译自: https://contexturesblog.com/archives/2009/04/01/autofilter-by-selection-in-excel-2007/

excel自动筛选