在Excel中反转过滤器选择 [英] Invert filter selection in Excel

问题描述

我要问的是我打算回答的问题，因此我可以持久地记录此问题.乐于让别人提出其他建议/更正.

I'm asking a question that I plan to answer so I can document this problem in a lasting way. More than happy for others to pitch in with other suggestions / corrections.

我经常在Excel中遇到一个问题，我正在使用过滤器，然后想要反转选择，即取消选择所有已选择的项目，然后选择所有当前未选择的项目.例如，请参见下面的屏幕截图:

I often have an issue in Excel where I'm using filters and then want to invert the selection i.e. unpick all the items that have been picked and pick all the items that are not currently picked. For example, see screenshots below:

除了点击列表(这很费力且容易出错)之外，没有其他简单的方法可以做到(据我所知！).我们如何在Excel中自动获得此功能?

There's no easy way to do this (that I know of!) other than clicking through the list, which laborious and error prone. How can we get this functionality automated in Excel?

之前:

之后:

推荐答案

一段时间以来，我一直在尝试解决此问题，并认为我发现了一种非常简单的逆过滤器方法.只需突出显示当前单元格，然后删除过滤器即可.现在，再次过滤未突出显示的所有内容，然后开始.希望对您有所帮助，它确实可以满足我的需求.

I've been trying to solve this issue for some time and think I just discovered a pretty easy way to inverse the filter. Just highlight the current cells, then remove the filter. Now filter again by everything not highlighted and there you go. Hope that helps, it certainly worked for what I needed.

这篇关于在Excel中反转过滤器选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！