excel合并单元格中筛选显示多行的方法

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

1、如图: 乡镇名称列选中锦和镇后：  这样显然不合适需求。。现在新建一空白列，将合并单元格格式刷到空白列 YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtracktrafficsystemintheofpart,foraccurategraspcitytracktrafficresear

2、chofobject 然后取消合并单元格，再填充上内容，如图： 然后将刚才刷过去的空白合并单元格刷回   这时显示应该是这样：YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtracktrafficsystemintheofpart,foraccurategraspcitytracktr

3、afficresearchofobject 然后使用筛选功能：  成功实现！！！YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtracktrafficsystemintheofpart,foraccurategraspcitytracktrafficresearchofobject