如何排序/过滤Excel中的合并单元格？ [英] How to sort/filter merged cells in Excel?

问题描述

我有两列 - 列A和列B.显示如下。

  A | B 
 --------- 
 a | 1 
 a | 2 
 b | 3 
 b | 1 
 b | 4 
 c | 2 
 c | 3 
 c | 4 
  

正如您所看到的，列A有许多冗余数据，所以我将它们合并在一起。如下所示。 （我需要摆脱冗余数据并正确表示它们，这是主要任务。）

  A | B 
 --------- 
 a | 1 
 | 2 
 --------- 
 | 3 
 b | 1 
 | 4 
 --------- 
 | 2 
 c | 3 
 | 4 
 --------- 
  

现在问题是我无法申请对两列进行排序/过滤功能。当我想对行进行排序时显示错误消息。过滤器也不能正常工作，例如当我检查 a ，我应该看到 1 和 2 在列B中，但是只有 1 显示在列B中。

所以我的问题是：我怎么能得到合并单元格的排序/过滤工作？

解决方案

填写单元格a，b， c用一种颜色和那种特定的颜色排序。然后，例如1和2将在彩色单元格a

上排序时显示

I have two columns - column A, and column B. Shown below.

  A  |  B
 ---------
  a  |  1
  a  |  2
  b  |  3
  b  |  1
  b  |  4
  c  |  2
  c  |  3
  c  |  4

As you can see, column A has many redundant data, so I merged them together. Shown below. (I need to get rid of redundant data and represent them properly. That's the main task.)

  A  |  B
 ---------
  a  |  1
     |  2
 ---------
     |  3
  b  |  1
     |  4
 ---------
     |  2
  c  |  3
     |  4
 ---------

Now the problem is I cannot apply sort/filter function to both column. Error message was displayed when I want to sort the row. Filter does not work properly also, for example when I checked a, I should see 1 and 2 in column B, however only 1 is shown in column B.

So my question is: how can I get the sort/filter work with merged cells?

解决方案

Fill your cells a,b,c with a color and sort on that specific color. Then for example the 1 and 2 will display when sorted on a colored cell "a"

这篇关于如何排序/过滤Excel中的合并单元格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！