excel合并單元格中篩選顯示多行的方法

《excel合并單元格中篩選顯示多行的方法》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。

1、如圖:?鄉(xiāng)鎮(zhèn)名稱列選中錦和鎮(zhèn)后：??這樣顯然不合適需求?！，F(xiàn)在新建一空白列，將合并單元格格式刷到空白列?YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtracktrafficsystemintheofpart,foraccurategraspcitytracktrafficresear

2、chofobject?然后取消合并單元格，再填充上內(nèi)容，如圖：?然后將剛才刷過去的空白合并單元格刷回???這時(shí)顯示應(yīng)該是這樣：YibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtracktrafficsystemintheofpart,foraccurategraspcitytracktr

3、afficresearchofobject?然后使用篩選功能：??成功實(shí)現(xiàn)?。。ibinCityCitytracktrafficplanningisYibincityregionalrangewithintracktrafficsystemofonceintegration,andcitytracktrafficalsoisYibinCityCityintegratedtracktrafficsystemintheofpart,foraccurategraspcitytracktrafficresearchofobject