excel合并单元格筛选

《excel合并单元格筛选》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、excel合并单元格筛选，是怎么做到的？含合并单元格表格如果直接筛选会出现下面的情况。（只筛选出第一条）如果想实现正确的筛选结果，需要对表格A列动一下手术。第一步：复制A列到E列。YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtracktrafficsystemintheofp

2、art,foraccurategraspcitytracktrafficresearchofobject第二步：取消A列合并第三步：选取A列，CTRL+G定位-空值，在编辑栏中输入=A2,再按CTRL+Enter完成填充YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtrackt

3、rafficsystemintheofpart,foraccurategraspcitytracktrafficresearchofobject第四步：复制A列，粘贴成数值（公式转换成数值）第五步：用格式刷把E列的格式刷到A列，恢复A列的合并格式。YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityin

4、tegratedtracktrafficsystemintheofpart,foraccurategraspcitytracktrafficresearchofobject“手术”完成后，就可以正常筛选了，如下图所示。YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtracktr

5、afficsystemintheofpart,foraccurategraspcitytracktrafficresearchofobject